time conversion

P

Pierre

I need to convert elapsed times from hours & minutes to
total minutes. For example 10:35 to 635. I tried making a
vlookup table to do it, but it sometimes returns a wrong
value. Help?
 
J

Juan Pablo González

Either format the cell as

[mm]

or use a formula like

=A1*24*60

and format as general.
 
A

Allan S. Warrior

Multiply your elapsed time cell by 1440 and format as a number.
For example, if d1 reads 3:15, your formula would be =D1*1440. Be sure to
format the cell as a number *not* a date/time.
 
Top