| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to convert Minutes:Seconds format to minutes with seconds con | Excel Worksheet Functions | |||
| How do I convert 1min and 15 seconds to all seconds | Excel Discussion (Misc queries) | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Threaded Mode
