Converting Text Field to Time

Is this possible?

Me

Yes, it is.

Mangesh

Probably, but what does the text field look like.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"A P" <ap@textguru.ph> wrote in message
news:uRvCdTHKFHA.3916@TK2MSFTNGP14.phx.gbl...
> Is this possible?
>
> Me
>
>

I have a time column with this format: 05:12 am but when I will run
autofilter, it doesn't identify a condition. Sample, I want to view time
which is less than 05:00 am. I've tried FOrmat cell and change it to Time
but still, autofilter doesnt work. What Im thinking is I will use a function
to convert the cell to time. Hope you get my question.

Me

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OZin1$HKFHA.4064@tk2msftngp13.phx.gbl...
> Probably, but what does the text field look like.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "A P" <ap@textguru.ph> wrote in message
> news:uRvCdTHKFHA.3916@TK2MSFTNGP14.phx.gbl...
> > Is this possible?
> >
> > Me
> >
> >
>
>

There's a possibility that your time is a text string, in which case it will not work. Just to test this, change the format of this cell to numbers, and your time should appear as a number and not remain the same. If it does not change to a number than your time is a text string.

To convert this text string you will have to use something like this:
=TIME(LEFT(A1,2),MID(A1,4,2),0)
Assumign that your time string is in cell A1

- Mangesh

Okay. Assuming the data is in A2:An, in B2 add this formula

=TIMEVALUE(A1)

and then copy down. Now filter on column B.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"A P" <ap@textguru.ph> wrote in message
news:Osu6YQPKFHA.1540@TK2MSFTNGP14.phx.gbl...
> I have a time column with this format: 05:12 am but when I will run
> autofilter, it doesn't identify a condition. Sample, I want to view time
> which is less than 05:00 am. I've tried FOrmat cell and change it to Time
> but still, autofilter doesnt work. What Im thinking is I will use a
function
> to convert the cell to time. Hope you get my question.
>
> Me
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:OZin1$HKFHA.4064@tk2msftngp13.phx.gbl...
> > Probably, but what does the text field look like.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "A P" <ap@textguru.ph> wrote in message
> > news:uRvCdTHKFHA.3916@TK2MSFTNGP14.phx.gbl...
> > > Is this possible?
> > >
> > > Me
> > >
> > >
> >
> >
>
>

Thanks Bob! thats what I need!


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OHgbZyTKFHA.2604@TK2MSFTNGP10.phx.gbl...
> Okay. Assuming the data is in A2:An, in B2 add this formula
>
> =TIMEVALUE(A1)
>
> and then copy down. Now filter on column B.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "A P" <ap@textguru.ph> wrote in message
> news:Osu6YQPKFHA.1540@TK2MSFTNGP14.phx.gbl...
> > I have a time column with this format: 05:12 am but when I will run
> > autofilter, it doesn't identify a condition. Sample, I want to view time
> > which is less than 05:00 am. I've tried FOrmat cell and change it to
Time
> > but still, autofilter doesnt work. What Im thinking is I will use a
> function
> > to convert the cell to time. Hope you get my question.
> >
> > Me
> >
> > "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> > news:OZin1$HKFHA.4064@tk2msftngp13.phx.gbl...
> > > Probably, but what does the text field look like.
> > >
> > > --
> > >
> > > HTH
> > >
> > > RP
> > > (remove nothere from the email address if mailing direct)
> > >
> > >
> > > "A P" <ap@textguru.ph> wrote in message
> > > news:uRvCdTHKFHA.3916@TK2MSFTNGP14.phx.gbl...
> > > > Is this possible?
> > > >
> > > > Me
> > > >
> > > >
> > >
> > >
> >
> >
>
>

you might like to check out the TIME function, if you'ld like more
assistance please post back with a sample or two of your "text" typed into
your reply.

Cheers
JulieD

"A P" <ap@textguru.ph> wrote in message
news:uRvCdTHKFHA.3916@TK2MSFTNGP14.phx.gbl...
> Is this possible?
>
> Me
>
>