Kindly give me the fomula to show Current Hour, Minute ,and Seconds in a cell

=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

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

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

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

Well, I am not in Mumbai, but in Goa (a little south of mumbai about 600
kms) and though we too had a lot of rains, but not much problems. As for
Mumbai, its recovering now and people are back to their work.

Mangesh


"Bob Phillips" wrote in message
...
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