Thread: Convert seconds to hh:mm:ss.dd ?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell Terry Pinnell is offline
external usenet poster
  
Posts: 46
Default Convert seconds to hh:mm:ss.dd ?
Gary''s Student wrote:

=A1/(24*60*60)
and format as:

Custom [h]:mm:ss.00

Thanks both!

--
Terry, West Sussex, UK
Reply With QuoteReply With Quote