how do i convert a column of minutes into hours

G

Guest

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

Guest

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
 

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

Similar Threads

How to convert minutes to fractional hours 4
Converting hour/minutes to hours/hundredths 1
Convert minutes into hours 3
coverting minutes to hours and minutes 1
calculating fees from hours and minutes 2
Converting Minutes and Seconds ([mm]:ss) to Decimal 6
Hours and sum of hours 2
Displaying hours and minutes 3

Top