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
Here you go:
=TEXT(1685/86400,"hh:mm:ss")
Note: Instead of 1685 give cell number for your convenience
|