# 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

C

#### Chip Pearson

Jackie,

Try the following formula:
=A1*24*60

where A1 contains the hours and minutes. Format the cell as
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.

P

#### Peo Sjoblom

With 3:40 in A1

=A1*1440

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