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"
