View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hafeez Esmail Hafeez Esmail is offline
external usenet poster
 
Posts: 22
Default Filter specific information and format

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