how do i convert a column of minutes into hours

C

Chrisj20

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

Niek Otten

In an empty cell, enter the number 60.
Edit>Copy.
Select your minutes.
Edit>Paste special>check Divide
 
G

Gary''s Student

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
 
Top