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

MP,

Assuming that your first times are in A3 and B3 - in A2 enter 18:00 and in B2 enter 20:00.

Then use this formula

=OR(AND($A$2<=B3,$B$2=B3),AND($A$2<=A3,$B$2=A3), AND($A$2<=A3,$B$2=B3),AND($A$2=A3,$B$2<=B3))

and copy down to match your data. The formula will return TRUE if there is any overlap at all. You
may want to change the <= and = to just < and ....

HTH,
Bernie
MS Excel MVP


"MP" wrote in message
...
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