Hi Terry,

Am Mon, 16 Nov 2015 20:31:11 +0000 schrieb Terry Pinnell:

Is it possible with a single formula to convert a number of seconds
sssss to the text hh:mm:ss please?

For example, 6185 would become 01:43:05.

divide the seconds by seconds per day.
Your seconds in A1. Then in B1:
=A1/86400
and format the result cell h:mm:ss


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional