Convert Integer (seconds) to hh:mm:ss

Posted by JAF on February 04, 2002 9:39 AM

Hiya

I'm trying to work out a formula that will take an integer value (a number of seconds) and convert it into a genuine time.

I've got several formulas that convert into Hours and Minutes, but none that generate Hours, Minutes AND Seconds.

Example:
58 = 00:00:58
64 = 00:01:04
3662 = 01:01:02
etc.

Any suggestions....?

Posted by Juan Pablo G. on February 04, 2002 9:45 AM

Use

=A1/86400

Where A1 holds the time. Format as hh:mm:ss or whatever you need.

Juan Pablo G.

Posted by JAF on February 04, 2002 10:52 AM

Thanks - obvious one - I was trying to be too clever!! :-)