Tom, Dianne, I can't thank you guys enough!
You've been a tremendous help!!!

Thanks again
Hafeez Esmail

-----Original Message-----
If your Windows settings recognise "dd/MMM/yyyy" as a
valid date format,
then you could add the following formula into another
column to convert
your date (which is currently being recognized as text)
and time into an
Excel-recognised date:

=DATEVALUE(SUBSTITUTE(SUBSTITUTE(A2," ",""),".","/"))

What this does is to remove the space from your date
string and then
changes the full stops(.) to slashes (since these are
often recognised
as valid date separators in Windows). Then it takes the
resulting string
and applies DATEVALUE to it to turn it into a date.

If you need to add the time to it, then

=DATEVALUE(SUBSTITUTE(SUBSTITUTE(A2," ",""),".","/"))+B2
or
=DATEVALUE(SUBSTITUTE(SUBSTITUTE(A2," ",""),".","/"))
+TIMEVALUE(B2)

Use the second one if Excel thinks B2 is a string rather
than a time.

Then use this column to filter your data.

--
HTH,
Dianne

In ,
Hafeez Esmail typed:
I've hit a road block and have spent a lot of time
trying
to over come it.

Field One is of category 'general' and will always
contian dates in the following format, "dd.MMM. YYYY"
(the
space is there intentionally). Field Two is a custom
category with the following format "h:mm:ss" where h can
be either one or two digits.

Due to the nature of the system, I get data from last
year. I'm only interested in data from a specific date
&
time (that I'll get from a file) to the most recent
date &
time.

How do I delete all the extrenuous information?

I'd appreciate any help you can give
Thanks

Hafeez Esmail


.