Thread: How can we convert 02:30 hours to 180 minutes?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How can we convert 02:30 hours to 180 minutes?
How can we convert 02:30 hours to 180 minutes?

You can't! But you can convert it to 150 minutes by multiplying by 1440:

A1 = 2:30

=A1*1440

Format as GENERAL or NUMBER 0 decimal places.

Result = 150

Biff

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



Reply With QuoteReply With Quote