Thread: Convert seconds to hh:mm:ss?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Frozen Frozen is offline
external usenet poster
  
Posts: 2
Default Convert seconds to hh:mm:ss?
On Tuesday, November 17, 2015 at 2:00:59 AM UTC+5:30, Terry Pinnell wrote:
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

<<<<<<<

=TEXT(1685/86400,"hh:mm:ss")
Reply With QuoteReply With Quote