Converting an integer of minutes to hours, minutes and seconds
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?