Convert hours and minutes into minutes


J

Jackie Parker

Could someone please assist in a formula that will convert
hours and minutes (in the same cell eg 3:40) into minutes
eg 220. Wondering if the hours will need to be in one
cell and the minutes in another?

Thanks.

Jackie
 
Ad

Advertisements

C

Chip Pearson

Jackie,

Try the following formula:
=A1*24*60

where A1 contains the hours and minutes. Format the cell as
General or numeric. For lots more information about working with
dates and times in Excel, see www.cpearson.com/excel/datetime.htm
..


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
P

Paul

Jackie Parker said:
Could someone please assist in a formula that will convert
hours and minutes (in the same cell eg 3:40) into minutes
eg 220. Wondering if the hours will need to be in one
cell and the minutes in another?

Thanks.

Jackie
If your time were in A1, use
=A1*24*60
or
=A1*1440
to convert to minutes. You will probably need to format the result cell as
General (or number) after entering the formula, as Excel will (unhelpfully)
format it as time.

Excel stores times as fractions of 1 day. This is why you have to multiply
by 24 to get number of hours, and then by 60 to get minutes.
 
Ad

Advertisements

P

Peo Sjoblom

With 3:40 in A1

=A1*1440

format result as general or number (else you get a time like 00:00)
 

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