If you only want to display it that way, Format Custom, [mm]
If you need to calculate with the minutes as a number, multiply by 24*60
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Brenda Rueter" wrote in message
...
Is there a function to convert 1:50 as an hour/minute time (one hour, 50
minutes) into the number of minutes (110 minutes)? TIA!
|