Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Forum,
I am trying to figure out a way to convert time data in the form of minutes (starting at 0 at 0:00) into a time format of hh:mm (so e.g. 360 would = 6:00 , and 780 would = 13:00 etc).
I have tried to use the MakeTime formula, but I must be doing it wrong. My approach was this:
MakeTime(Floor(TIMEinMINUTES/60),60*((TIMEinMINUTES/60)-Floor(TIMEinMINUTES/60)))
Any suggestions and help would be greatly appreciated!
Thank you very much,
Ferdi
How about using Mod and Div?
=MakeTime(Div(TimeInMinutes,60), Mod(TimeInMinutes,60))
Try this:
time#(num(floor(TIMEinMINUTES/60), '00') & ':' & num(TIMEinMINUTES-(floor(TIMEinMINUTES/60)*60), '00'), 'hh:mm')
Just thought about what if you have TIMEinMINUTES = 10000? May be you want more sophisticated solution which can produce you in formaxt: "x days y hours and z minutes". Depends on what you trying to do. Anyway, you get the idea.
Hi guys,
Thanks so much for your input!
Actually I just needed to step back for a second and breathe 🙂 The Coffee break brought enlightenment-
The solution is this: "TIMEinMINUTES"/60/24 and formated in hh:mm
Thanks again anyway, I really appreciate your help
🙂