Converting seconds to hh:mm:ss

[Guest]

Is there a function or formula to convert say 32,897 seconds to hh:mm:ss?

Thanks Chris

 

[Max]

With the time in seconds in A1,

Try: =A1/(60*60*24)

Format A1 as custom: [hh]:mm:ss
(to allow hours to roll over 24 hours)

 

[Bob Phillips]

Chris,

If the secs are in a1, create formula
=A1/(24*60*60)
in B1, and format it as time.

 

[Max]

Oops, typo correction ..

Format A1 as custom: [hh]:mm:ss

The formula cell (say B1), not A1,
should be the one formatted

 

[Dana DeLouis]

If you forget the formula in the future, the Function is
=CONVERT(32897,"sec","day").

HTH
Dana DeLouis

 

[Guest]

Hi Dana,

This is giving me a #NAME? error. I believe it is occuring at the "sec" and
"day" arguments.

 

[Dana DeLouis]

Hello. Sound like you do not have the Analysis ToolPak add-in loaded. From
help on "Convert"...

"...if this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in."

Do: Tools | Add-Ins... and select "Analysis ToolPak.

Using the formula that others gave you is probably better because you do not
have to load this. Just thought it might be something you would find
interesting.

Another technique that is sometimes neat is to add a range name with the
value of the formula =1/(60*60*24). Call the name something meaningfull.
Then you can do something like...

=32897*SecToDay

This way, down the road, you may forget what the following equation is
doing:
=32897 * 0.000011574074074074


Just a thought.
Dana DeLouis