minutes to time formula

  • Thread starter Thread starter Hartsell
  • Start date Start date
H

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
 
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....
 
Hartsell said:
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
Click to expand...

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.
 
Back
Top