Hi Mangesh,

I understand now :-)

How is your city? Is it getting back to normality?

Regards

Bob

"Mangesh Yadav" wrote in message
...
Hi Bob,

somehow I have the feeling that the OP wants a clock in the cell, and
thats
why I meant to say "it is static".
:)

Mangesh


"Bob Phillips" wrote in message
...
it is NOT static is what I think Mangesh means, meaning that it changes
when
the sheet recalculates.

Also, ensure that you format as hh:mm:ss else you get the date as well.

--
HTH

Bob Phillips

"Mangesh Yadav" wrote in message
...
=NOW()

but this is static

Mangesh



"Dr.H.Subramanian" wrote in
message ...
Kindly give me the fomula to show Current Hour, Minute ,and Seconds
in
a
cell