View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default Excel Time Conversion

"radiaz via OfficeKB.com" <u12799@uwe wrote in message
news:669357d70a249@uwe...
Hello Guys,
I'm having a problem converting times to minutes in Excel. Can you please
help?

For example

how can I convert this 32:23:14 to minutes ( 5,707 minutes)


Well to convert it to minutes, use =A1*24*60, and format the answer as
general, but it's 1943.233 minutes, not 5707.

5707 minutes would be more than 95 hours.
--
David Biddulph