Formula for Hour Minute and Second
 

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

Hi Mangesh,

Glad to hear it is recovering, it looked awful from over here.

I just saw that your ISP was in Mumbai, so that and the fact that Mumbai
would probably offer good job opportunities for someone with your skills, I
put 2 and 2 together (and got 4 and a half, not quite 5 :-))

My wife keeps wanting to visit Goa, so maybe soon we will make it.

Regards

Bob

"Mangesh Yadav" wrote in message
...
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

Infact if you are in India and in IT, then most of the time you would be
either in Mumbai or Bangalore, so its quite logical for you to think so. I
was in mumbai about three and a half years back, but then shifted to goa
(which is a home-town for me and a nice place to stay).

You are most welcome to Goa, and please do let me know whenever you are down
here.

Mangesh



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

Glad to hear it is recovering, it looked awful from over here.

I just saw that your ISP was in Mumbai, so that and the fact that Mumbai
would probably offer good job opportunities for someone with your skills,
I
put 2 and 2 together (and got 4 and a half, not quite 5 :-))

My wife keeps wanting to visit Goa, so maybe soon we will make it.

Regards

Bob

"Mangesh Yadav" wrote in message
...
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