Converting hours to minutes


K

KSGORE

I am new to excel and I need help. I need to convert hours 01:10 to
minutes 70. For one column A. What is the formula and how to I format
it for the whole column not just one cell?
 
Ad

Advertisements

B

Bob Phillips

Multiply by 1440 (24 hours per day by 60 minutes per hour)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
G

Guest

Select column A and pull-down:

Format > Cells... > Number > Custom and enter [m] in the type field
 
Ad

Advertisements

G

Guest

To convert a time into a number of minutes, multiply by 1440, then format as
a simple number (comma style, for example) rather than a time. To do this
for a whole series of numbers, type the number 1440 in some random cell.
Copy it. Then select all the times you want converted and Edit > Paste
Special. Select the 'multiply' option and click OK. Then apply the
formatting.

BTW, the logic for 1440: Excel stores dates/times as numbers, specially
formatted, with the integer portion being days and the fraction portion being
parts of a day. There are 24 hours in a day, so multiply by 24 to get the
number of hours. Then multiply by 60 to convert hours to minutes.
--Bruce
 

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

Top