3 Replies Latest reply: May 6, 2010 12:40 PM by Ferdiism

# How to convert minutes into hh:mm ?

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 to convert minutes into hh:mm ?

How about using Mod and Div?

`=MakeTime(Div(TimeInMinutes,60), Mod(TimeInMinutes,60))`

• ###### How to convert minutes into hh:mm ?

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.

• ###### How to convert minutes into hh:mm ?

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

:)