Thread: How do I convert a # into a time format in Excel, Ex.845 to 8:45
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav
 
Posts: n/a
Default How do I convert a # into a time format in Excel, Ex.845 to 8:45

times are stored as part of a day so for example 6am is 0.25, midday is
0.5,

To convert your times If the time is stored in cell a1 try something
like

=INT(A1/100)/24+MOD(A1,100)/24/60

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=538835

Reply With QuoteReply With Quote