Concerting total minutes to hours and minutes
 

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.

Concerting total minutes to hours and minutes
 

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

Concerting total minutes to hours and minutes
 

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

"Randi" wrote in message
...
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.

Concerting total minutes to hours and minutes
 

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?

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

Concerting total minutes to hours and minutes
 

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.

Concerting total minutes to hours and minutes
 

That works. Thanks for your help.

"David Biddulph" wrote:

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

"Randi" wrote in message
...
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.

Concerting total minutes to hours and minutes
 

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

format cell as General


"Randi" wrote:

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?

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

Concerting total minutes to hours and minutes
 

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.