Convert hours and minutes into minutes

  • Thread starter Thread starter Jackie Parker
  • Start date Start date
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
 
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
 
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
Click to expand...

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.
 
With 3:40 in A1

=A1*1440

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