Convert no. to time

[Bhuktar S]

I put a counter on excel VBA form.
The counter updates to new no. by adding 1 per second.
I want to convert this value & display as h:m:s.
How do I do it

 

[Bob Phillips]

Either

If the secs are in a1, create formula
=A1/(24*60*60)
in B1, and format it as time.

or

=CONVERT(A1,"sec","day")
in B1, and format it as time.