Minutes to hours
by ricky fernandez on 10/11/05 at 23:13:24

Need help pls.
Is there a formula in Excel that I can use to convert minutes to hours (and vice versa) from multiple cells?
Your help is greatly appreciated.
Thanks!

Re: Minutes to hours
by Robert Fogt on 10/15/05 at 00:42:18

Depends a bit on exactly what you are trying to do.

If your number of minutes is in cell A1, then the formula for number of hours would be:
=A1/60

Though that would give you the decimal hour.

If you want hours + minutes, it would be:
=INT(A1/60)&" hours "&ROUND(((A1/60)-INT(A1/60))*60,0)&" minutes"

Go Back | Archive Index