Try

=A1/24/60/60

or

=A1/86400

formats as hh:mm:ss


--

Regards,

Peo Sjoblom

"PCLIVE" wrote in message
...
I've got a cell with the total number of seconds in it.

A1 contains the number: 3,157

This number represents seconds. Is there a format or function that will
display this in hours-minutes-seconds (hh:mm:ss)?

Thanks,
Paul