Welcome to OnlineConversion.com

Minutes to hours

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.

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:

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


Did you find us useful?

Please consider supporting the site with a small donation.

click here for more information


BookMark Us

It may come in handy.

Check out our Conversion Software for Windows.

Can't find something?
Try searching.

Are you bored?
Try the Fun Stuff.

Was this site helpful?
Link to Us | Donate