Include number of days in time format

[dukane24]

Hello,

I am looking to simply add the number of days to a H:MM:SS time format.  I have noticed using this format that if the number of hours is greater than 24, it shows as 0.

As an example, if the value was 27.5 hours, I would like this to display as 1:03:30:00 (1 day, 3 hours, 30 minutes, 0 seconds).

Thanks for your help!

[sergio0592]

Hi, try with :

=interval(Your_field/24,'D HH:mm:ss')

[rwunderlich · Accepted solution]

Why divide by 24?  Wouldn't it just be:

=interval(Your_field, 'd hh:mm:ss')

-Rob