minutes to time formula

[Hartsell]

I am paniking. I need to change numbers that represent
minutes to a time format. Specifically i have a length of
time in B2 that is 574 minutes. I need to convert this to
hours:minutes. I have found a way to make 9:34 through
several formulas but every 1 out of 6 entries is way off.
Can someone help.

Thanks in advance.
Bryan

 

[hartsell]

I did find a formula =int(a1/60) for the hours and mod
(a1,60) for the minutes. The problem is the for the 1st
ten minutes out of every hour the results read x:1, x:2...
instead of x:01, x:02....

 

[Anon]

I am paniking. I need to change numbers that represent
minutes to a time format. Specifically i have a length of
time in B2 that is 574 minutes. I need to convert this to
hours:minutes. I have found a way to make 9:34 through
several formulas but every 1 out of 6 entries is way off.
Can someone help.

Thanks in advance.
Bryan

With the number 574 in A1, you would use the formula
=A1/1440
(as there are 1440 minutes in a day)
and format as time.

If the number of hours can be more than 24, you need to use the format
[h]:mm (rather than h:mm). This may be your problem.