If you want to convert from minutes to decimal hours, you can divide by 60
(either using a formula or using Paste Special/ Divide).
If you want to convert to Excel time (which you can format as hours and
minutes), then divide your minutes by 1440 as suggested below (i.e. 24*60).
--
David Biddulph

"Randi" wrote in message
...
Actually, upon further reflection, I need to change the total minutes into
the hours and minutes. Otherwise I have to re-enter all the data. I can
divide total minutes by 60 - but what formula can I use to get the minutes
correctly, i.e., 500 total minutes/ 60 = 8.33; .33 x 60 = 19.8 or 20
minutes
rounded up. Thanks

"Teethless mama" wrote:

=A1/1440

Format cell as h:mm

"Randi" wrote:

I have a column of minutes which totals 500 minutes.
I want to convert it to hours and minutes. What formula
can I use to get it to the 8 hours 20 mins. Also what should my
cells be formatted as? Is there a way to bypass the total minutes all
together and have it compute directly into the 8 hours 20 mins?
Thanks.