A
A P
Is this possible?
Me
Me
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Probably, but what does the text field look like.
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
J
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
assistance please post back with a sample or two of your "text" typed into
your reply.
Cheers
JulieD
A
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
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
B
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)
=TIMEVALUE(A1)
and then copy down. Now filter on column B.
--
HTH
RP
(remove nothere from the email address if mailing direct)
A
A P
Thanks Bob! thats what I need!
Bob Phillips said: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)