Thread: How do I convert run time(45,502h 30m) to number 45,502.5 ??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default How do I convert run time(45,502h 30m) to number 45,502.5 ??

If your run time is an actual time then to convert to decimal hours just
multiply by 24 and format as a number - or is it text - in which case
can you give the exact format


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=542285

Reply With QuoteReply With Quote