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

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

• ###### 1. Re: how to convert calculated time duration between two dates from fraction of day to hh:mm:ss

Well, that seemed to work except I need the average time to resolution in hh:mm:ss and with DATETIME at the beginning it will not let me average it....

Could you help me with that?

Maybe I have to leave it as a number and then convert it to hh:mm:ss?

This was tricky in excel too, and I had to do the calculation before formatting the numbers in the column.

Thank you!

• ###### 3. Re: how to convert calculated time duration between two dates from fraction of day to hh:mm:ss

I am unable to format the average resolution time as hh:mm:ss no matter where I add the formatting in the calculation.

This could be me as I am very new and was actually in training last week but it seemed to stump everyone outside of converting to a string and then back which confused me.

Thank you!