Thread: Convert seconds to hh:mm:ss?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell[_4_] Terry Pinnell[_4_] is offline
external usenet poster
  
Posts: 192
Default Convert seconds to hh:mm:ss?
Is it possible with a single formula to convert a number of seconds
sssss to the text hh:mm:ss please?

For example, 6185 would become 01:43:05.

--
Terry, East Grinstead, UK
Reply With QuoteReply With Quote