minutes to time formula


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
 
Ad

Advertisements

H

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....
 
Ad

Advertisements

A

Anon

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top