View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default Date / Time Filter

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)