Thread: Converting decimal time to standard time?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
protonLeah
 
Posts: n/a
Default Converting decimal time to standard time?

Try:

=TRUNC(A1) & ":" & (A1-TRUNC(A1))*60


Ben


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=541322

Reply With QuoteReply With Quote