View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jbosrock
 
Posts: n/a
Default 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