| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert seconds (up to 38,000) into HR:MN:SEC?
I have data downloaded into Excel that gives the time span in seconds only.
For example, I have a driver at a location for 1 hrs:4 mins:44 secs - the time is downloaded as "3884" seconds. I want to convert that to HR:MN:SEC. I can also get days downloaded as seconds: 1 day:9 hrs:59 mins:49 secs would download as "122389" seconds. Help, please!!!! Thank you, Joan Bosrock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help: convert seconds to date and time | Excel Discussion (Misc queries) | |||
| convert duration (hr:mn:sec) in to equivalent sec | Excel Discussion (Misc queries) | |||
| Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
| How do I convert 00:03:54 to get 234 seconds? | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Threaded Mode
