Converting an integer of minutes to hours, minutes and seconds

[Dayna]

Hi All,

I tried to search the forums but couldn't find a response that was clear for this... I have a value of time in minutes that I'd like to format as hhh:mm:ss, I was thinking interval but this is giving me a really high number.

For example, my value in minutes is 48.9666666667

I was thinking that interval needs to work in seconds so I divided this by 60 to give 0.81611111111

If I then do interval as: interval(time/60,'hhh:mm:ss) I get 019:35:12.

This is clearly wrong, as I know the value is 48 minutes and 59 seconds. Can someone help how I should proceed here, please?

Kind Regards,

Dayna

[daveamz · Accepted solution]

You can use =Interval(48.9666666667/60/24)

Regards,

David

[Dayna]

Thank you!