3 Replies Latest reply on Nov 14, 2014 6:52 AM by Julie Montemayor

    how to convert calculated time duration between two dates from fraction of day to hh:mm:ss

    Julie Montemayor

      I used this calculation:

      (DATEDIFF('week',[Reported Date],[Solved Date])*5

      +

      MIN(DATEPART('weekday',[Solved Date]),6)

      -

      MIN(DATEPART('weekday',[Reported Date]),6))

       

      Which worked perfectly to calculate the difference between dates using only workdays, but the results are showing as fractions of a day.

      I thought I would be able to simply change the format to hh:mm:ss but that option is not available.

      Any help is appreciated!

      Thank you!

      Julie