Converting Text Field to Time

[A P]

Is this possible?

Me

 

[Bob Phillips]

Probably, but what does the text field look like.

--

HTH

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

 

[JulieD]

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]

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]

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]

Thanks Bob! thats what I need!

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)