In B2 enter =A1/(24*60*60) and you should see 0.036539352
format as hh:mm:ss and you will see 00:52:37
___________________________________________
Gary's Student


"PCLIVE" wrote:

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