View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 299
Default How can we convert 02:30 hours to 180 minutes?

Multiply with 1440 (24*60) and format as general or number

Note that 2:30 is not 180 minutes, it is 150 minutes

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Omar" wrote in message
ups.com...
Dear Experts,
How can we convert 02:30 hours to 180 minutes?
Thanks.