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.
--
HTH
RP
"Bhuktar S" wrote in message
...
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?
--
Bhuktar S
------------------------------------------------------------------------
Bhuktar S's Profile:
http://www.excelforum.com/member.php...fo&userid=2343
View this thread: http://www.excelforum.com/showthread...hreadid=264544