time conversion

[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?

 

[Juan Pablo González]

Either format the cell as

[mm]

or use a formula like

=A1*24*60

and format as general.

 

[Guest]

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.