View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MP MP is offline
external usenet poster
 
Posts: 39
Default Filtering Time ranges

I have data that includes 2 columns for a Start Time and a Finish Time of a
task.
I want to be able to find all data that falls between a set time:
e.g. want to find data that falls between 18:00 and 20:00. this may include
data that has a Start Time of 17:45 and a Finish time of 20:30.
Can anybody help with this please.
MP