how do i convert a column of minutes into hours
 

I have a column of minutes in an excel spreadsheet which I want to convert
into hours and minutes as a decimal. i.e. I want to divide all the entries
by 60. Is there an easy way of doing this?

how do i convert a column of minutes into hours
 

In an empty cell, enter the number 60.
EditCopy.
Select your minutes.
EditPaste specialcheck Divide

--
Kind regards,

Niek Otten

"Chrisj20" wrote in message
...
I have a column of minutes in an excel spreadsheet which I want to convert
into hours and minutes as a decimal. i.e. I want to divide all the
entries
by 60. Is there an easy way of doing this?

how do i convert a column of minutes into hours
 

lets say A1 contains 500 (500 minutes) becasue time is a fraction of a day:
=A1/24/60 will yield 0.347222222
formatted as time will display as 8:20
--
Gary's Student


"Chrisj20" wrote:

I have a column of minutes in an excel spreadsheet which I want to convert
into hours and minutes as a decimal. i.e. I want to divide all the entries
by 60. Is there an easy way of doing this?