Converting multiple day decimal value to total hh:mm:ss

[jay_pee]

Hi, I have a field that has a decimal value for the total time in days that a task has taken. This value can be greater than a single day i.e.

0.0044560185197042 = 00h:06m:25s

1.243738425932 is 29h:50m:59s

10.680914351848 = 256h:20m:31s

I'm having trouble calculating these numbers (in the load editor) into total hours:minutes:seconds like 256:20:31, I've tried interval and time functions but the hours are never correct as some of them have a value greater than a single day.

How can I calculate this decimal/percentage value of total days in the load editor to get a new field with the correct amount of hours as a total with the remaining hours and minutes.

[Or · Accepted solution]

Interval() is the function you're looking for.

For example, =Interval(10.680914351848,'hh:mm:ss')

Will return

[jay_pee]

Thanks a lot @Or , I did try that initially and wasn't getting the correct results but for some reason when I tried it again after your suggestion it worked 🙂

I must have done something wrong the first time! Thanks for your help., James

[Or]

Sure thing. Perhaps you tried doing it with HH:MM:SS in uppercase? That won't work properly.