Thread: How do convert time into numeric
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vito
 
Posts: n/a
Default How do convert time into numeric

If you still want to keep the "Time" format, you can go to Format|Cells
and choose Custom from the list, then type [h].

or if you want the number format, use: =ROUND(A1*24,0) and format as
number, where A1 contains the original time.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489414

Reply With QuoteReply With Quote