I have a list of date time cells that are formatted as m/d/yyyy h:mm. The
list is of two consecutive days worth of various times. I need to filter the
list to only show the times that occur between 02:00 on the first date and
02:00 on the second date. ex.(01/13/2009 02:00 thru 01/14/2009 02:00)

Hi,

Go to data and apply auto filter. When auto filter is applied click on the
drop down list and select custom.

Enter the desired formula and it will give the result accordingly.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Teddy-B" wrote:

I have a list of date time cells that are formatted as m/d/yyyy h:mm. The
list is of two consecutive days worth of various times. I need to filter the
list to only show the times that occur between 02:00 on the first date and
02:00 on the second date. ex.(01/13/2009 02:00 thru 01/14/2009 02:00)

Thanks Suleman for your reply:

I ended up using your suggestion in accompaniment with these helper cells:
0:00 1/0/1900 0:00 FALSE
0:00 Time Out Time Out
=0 <=FALSE
The left time cells and the date cell reference another set of visible cells
that the user may input any parameters that they choose. Then a macro uses
your custom filter idea to filter the list according to the helper cells.
There may have been a formula that I could have written into custom filter
that would do all of this without the helper cells, but that is defininately
beyond my scope of knowlege.

Regards, and thanks again for your reply. It is always nice to know that we
have unseen friends in our community that can help us when called upon.

~Teddy-B

"Suleman Peerzade" wrote:

Hi,

Go to data and apply auto filter. When auto filter is applied click on the
drop down list and select custom.

Enter the desired formula and it will give the result accordingly.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Teddy-B" wrote:

I have a list of date time cells that are formatted as m/d/yyyy h:mm. The
list is of two consecutive days worth of various times. I need to filter the
list to only show the times that occur between 02:00 on the first date and
02:00 on the second date. ex.(01/13/2009 02:00 thru 01/14/2009 02:00)