Formula for Hour Minute and Second

D

Dr.H.Subramanian

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

Bob Phillips

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.
 
M

Mangesh Yadav

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
 
B

Bob Phillips

Hi Mangesh,

I understand now :)

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

Regards

Bob
 
M

Mangesh Yadav

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
 
B

Bob Phillips

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 said:
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 said:
Hi Mangesh,

I understand now :)

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

Regards

Bob
Click to expand...
Click to expand...
 
M

Mangesh Yadav

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 said:
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
Click to expand...
 
Top