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

How do I convert seconds (up to 38,000) into HR:MN:SEC?
 

Joan,

If your number of seconds is in A1 use this in B1.

=CONVERT(A1,"sec","day")

You need to format the result as [h]:mm:ss to get the desired output.
To do so, in the cell with the formula, FormatCustomType: manually
type in [h]:mm:ss here if it is not already an option in the list.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524958

How do I convert seconds (up to 38,000) into HR:MN:SEC?
 

=B28/24/3600 will convert 3884 to 1:04:44 and 122389 to 33:59:49. The trick
is to format the cells as [hh]:mm:ss. The square brackets around the hours
lets Excel keep on adding the hours. Without the brackets, the answer would
be 09:59:49

"jbosrock" wrote:

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

How do I convert seconds (up to 38,000) into HR:MN:SEC?
 

I figured it out. Thanks anyway :-)

"jbosrock" wrote:

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

How do I convert seconds (up to 38,000) into HR:MN:SEC?
 

Hi Steve & Kassie,

Sorry, I didn't see your posts when I put my second one in (I forgot to
refresh-oops). Thanks for your quick response, I really appreciate it. I've
never used this forum before and will definitely come back.

What I ended up doing was dividing the seconds by 86400 (sec in a day) and
then custom formating the cell as d hh:mm:ss.

Take care and thanks again, Joan

"jbosrock" wrote:

I figured it out. Thanks anyway :-)

"jbosrock" wrote:

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