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" <DrHSubramanian@discussions.microsoft.com> wrote in
message news:A8A86F5E-E6E8-4EF2-975A-CB53C029605A@microsoft.com...
> 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:eWwXyuXnFHA.3312@tk2msftngp13.phx.gbl...
> =NOW()
>
> but this is static
>
> Mangesh
>
>
>
> "Dr.H.Subramanian" <DrHSubramanian@discussions.microsoft.com> wrote in
> message news:A8A86F5E-E6E8-4EF2-975A-CB53C029605A@microsoft.com...
> > 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" <bob.phillips@notheretiscali.co.uk> wrote in message
news:#GYlSPYnFHA.2180@TK2MSFTNGP15.phx.gbl...
> 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
> news:eWwXyuXnFHA.3312@tk2msftngp13.phx.gbl...
> > =NOW()
> >
> > but this is static
> >
> > Mangesh
> >
> >
> >
> > "Dr.H.Subramanian" <DrHSubramanian@discussions.microsoft.com> wrote in
> > message news:A8A86F5E-E6E8-4EF2-975A-CB53C029605A@microsoft.com...
> > > 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:u0w7naYnFHA.3316@tk2msftngp13.phx.gbl...
> 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" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:#GYlSPYnFHA.2180@TK2MSFTNGP15.phx.gbl...
> > 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
> > news:eWwXyuXnFHA.3312@tk2msftngp13.phx.gbl...
> > > =NOW()
> > >
> > > but this is static
> > >
> > > Mangesh
> > >
> > >
> > >
> > > "Dr.H.Subramanian" <DrHSubramanian@discussions.microsoft.com> wrote in
> > > message news:A8A86F5E-E6E8-4EF2-975A-CB53C029605A@microsoft.com...
> > > > 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" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uQWjFzYnFHA.1468@TK2MSFTNGP12.phx.gbl...
> Hi Mangesh,
>
> I understand now :-)
>
> How is your city? Is it getting back to normality?
>
> Regards
>
> Bob
>
> "Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
> news:u0w7naYnFHA.3316@tk2msftngp13.phx.gbl...
> > 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" <bob.phillips@notheretiscali.co.uk> wrote in message
> > news:#GYlSPYnFHA.2180@TK2MSFTNGP15.phx.gbl...
> > > 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
> > > news:eWwXyuXnFHA.3312@tk2msftngp13.phx.gbl...
> > > > =NOW()
> > > >
> > > > but this is static
> > > >
> > > > Mangesh
> > > >
> > > >
> > > >
> > > > "Dr.H.Subramanian" <DrHSubramanian@discussions.microsoft.com> wrote
in
> > > > message news:A8A86F5E-E6E8-4EF2-975A-CB53C029605A@microsoft.com...
> > > > > 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:%23suN9bZnFHA.3312@TK2MSFTNGP12.phx.gbl...
> 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" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:uQWjFzYnFHA.1468@TK2MSFTNGP12.phx.gbl...
> > Hi Mangesh,
> >
> > I understand now :-)
> >
> > How is your city? Is it getting back to normality?
> >
> > Regards
> >
> > Bob
> >
> > "Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
> > news:u0w7naYnFHA.3316@tk2msftngp13.phx.gbl...
> > > 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" <bob.phillips@notheretiscali.co.uk> wrote in message
> > > news:#GYlSPYnFHA.2180@TK2MSFTNGP15.phx.gbl...
> > > > 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
> > > > news:eWwXyuXnFHA.3312@tk2msftngp13.phx.gbl...
> > > > > =NOW()
> > > > >
> > > > > but this is static
> > > > >
> > > > > Mangesh
> > > > >
> > > > >
> > > > >
> > > > > "Dr.H.Subramanian" <DrHSubramanian@discussions.microsoft.com>
wrote
> in
> > > > > message news:A8A86F5E-E6E8-4EF2-975A-CB53C029605A@microsoft.com...
> > > > > > 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" <bob.phillips@notheretiscali.co.uk> wrote in message
news:O6HLGmZnFHA.1372@TK2MSFTNGP10.phx.gbl...
> 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
> news:%23suN9bZnFHA.3312@TK2MSFTNGP12.phx.gbl...
> > 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" <bob.phillips@notheretiscali.co.uk> wrote in message
> > news:uQWjFzYnFHA.1468@TK2MSFTNGP12.phx.gbl...
> > > Hi Mangesh,
> > >
> > > I understand now :-)
> > >
> > > How is your city? Is it getting back to normality?
> > >
> > > Regards
> > >
> > > Bob
> > >
> > > "Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
> > > news:u0w7naYnFHA.3316@tk2msftngp13.phx.gbl...
> > > > 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" <bob.phillips@notheretiscali.co.uk> wrote in message
> > > > news:#GYlSPYnFHA.2180@TK2MSFTNGP15.phx.gbl...
> > > > > 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
> > > > > news:eWwXyuXnFHA.3312@tk2msftngp13.phx.gbl...
> > > > > > =NOW()
> > > > > >
> > > > > > but this is static
> > > > > >
> > > > > > Mangesh
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Dr.H.Subramanian" <DrHSubramanian@discussions.microsoft.com>
> wrote
> > in
> > > > > > message
news:A8A86F5E-E6E8-4EF2-975A-CB53C029605A@microsoft.com...
> > > > > > > Kindly give me the fomula to show Current Hour, Minute ,and
> > Seconds
> > > in
> > > > a
> > > > > > cell
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>