Joan,

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

=CONVERT(A1,"sec","day")

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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524958