software

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 quot;3884quot; 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 quot;122389quot; seconds.

Help, please!!!!

Thank you, Joan Bosrock


Joan,

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

=CONVERT(A1,quot;secquot;,quot;dayquot;)

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

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=524958=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

quot;jbosrockquot; wrote:

gt; I have data downloaded into Excel that gives the time span in seconds only.
gt; For example, I have a driver at a location for 1 hrs:4 mins:44 secs - the
gt; time is downloaded as quot;3884quot; seconds. I want to convert that to HR:MN:SEC.
gt;
gt; I can also get days downloaded as seconds: 1 day:9 hrs:59 mins:49 secs would
gt; download as quot;122389quot; seconds.
gt;
gt; Help, please!!!!
gt;
gt; Thank you, Joan Bosrock

I figured it out. Thanks anyway :-)

quot;jbosrockquot; wrote:

gt; I have data downloaded into Excel that gives the time span in seconds only.
gt; For example, I have a driver at a location for 1 hrs:4 mins:44 secs - the
gt; time is downloaded as quot;3884quot; seconds. I want to convert that to HR:MN:SEC.
gt;
gt; I can also get days downloaded as seconds: 1 day:9 hrs:59 mins:49 secs would
gt; download as quot;122389quot; seconds.
gt;
gt; Help, please!!!!
gt;
gt; Thank you, Joan Bosrock

Hi Steve amp; 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

quot;jbosrockquot; wrote:

gt; I figured it out. Thanks anyway :-)
gt;
gt; quot;jbosrockquot; wrote:
gt;
gt; gt; I have data downloaded into Excel that gives the time span in seconds only.
gt; gt; For example, I have a driver at a location for 1 hrs:4 mins:44 secs - the
gt; gt; time is downloaded as quot;3884quot; seconds. I want to convert that to HR:MN:SEC.
gt; gt;
gt; gt; I can also get days downloaded as seconds: 1 day:9 hrs:59 mins:49 secs would
gt; gt; download as quot;122389quot; seconds.
gt; gt;
gt; gt; Help, please!!!!
gt; gt;
gt; gt; Thank you, Joan Bosrock