Concerting total minutes to hours and minutes

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

 

[Teethless mama]

=A1/1440

Format cell as h:mm

 

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

 

[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?

 

[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

 

[Randi]

That works. Thanks for your help.

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

 

[Teethless mama]

No problem
=MOD(A1/60,1)*60

format cell as General

 

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