G
Guest
Kindly give me the fomula to show Current Hour, Minute ,and Seconds in a cell
M
Mangesh Yadav
=NOW()
but this is static
Mangesh
but this is static
Mangesh
cellDr.H.Subramanian said:
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.
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
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
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
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
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
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
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