Advance Filter Formula

[Guest]

Can anyone help? I need a formula to filter data in a list according to
date/time - 24 hr clock. My time feilds are imported as (ex. 12-05-06 20:07).
I want to filter the list from 02:00 on one date to 02:00 on the following
day's date.

Thanks for your help!

 

[Peo Sjoblom]

You can do this using the advanced filter, you can create a criteria range
in for instance
A1:B2

in A1 and B1 put the header for the date/times (yes the same header both in
A1 and B1)

in A2 put =">="&D1

in B2 put ="<="&E1

now in D1 put the date and time of the starting filter values, for instance
12-05-06 02:00
in E1 put 12-06-06 02:00

it will look strange in A2 and B2 since the numerical value of for instance
the first value is

=39066.0833333333

select the table, do data>filter>advanced filter, click in the criteria
range and select A1:B2,
if you want the filtered values in a separate area select copy to another
location and click OK



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Guest]

Peo:
This formula works awesome. Thanks for you help again. I would have
never figured this one out without your help.

Best regards:

Teddy