convert hours and minutes to minutes
 

I need to convert hours and minutes 1:45 (One Hour and 45 Minutes) into total
minutes... Any ideas

Use a formula like the following:

=A1*24*60

Format the cell as General or Number.


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



"idaho" wrote in message
...
I need to convert hours and minutes 1:45 (One Hour and 45
Minutes) into total
minutes... Any ideas

If it's just formatting you want. Try this Custom Format:
[m]

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"idaho" wrote in message
...
I need to convert hours and minutes 1:45 (One Hour and 45 Minutes) into
total
minutes... Any ideas