Concerting total minutes to hours and minutes

R

Randi

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

David Biddulph

If you have 500 in A2, use =A2/(24*60) and format as time.
Alternatively, just enter the data as 8:20 (using a colon as the separator).
 
R

Randi

The cells that I am adding are in mins. Is there a way to just have "20"
mins in a cell rather than 0:20?
 
R

Randi

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
 
R

Randi

That works. Thanks for your help.

David Biddulph said:
If you have 500 in A2, use =A2/(24*60) and format as time.
Alternatively, just enter the data as 8:20 (using a colon as the separator).
 
D

David Biddulph

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

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