Hi Claus,

Excellent, thank you - I was hoping you'd be around!

That combination of formatting and formulas is a powerful one I must
try to use more often.

Best wishes,

--
Terry, East Grinstead, UK

====================

Claus Busch wrote:

Hi Terry

Am Mon, 16 Nov 2015 21:42:29 +0100 schrieb Claus Busch:

=A1/86400

or without a helper column:
Write 86400 in a empty cell = copy that cell = select all cells with
your seconds = Paste Special = Divide = Format the cells hh:mm:ss


Regards
Claus B.