View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

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!