I have a table containing two times, a start and a finish time for various jobs.
I have a second table containing the start time of other jobs, and my aim is to look at each start time in Table2, and see if it clashes with the times in Table 1.
So I want to look at each time in Table 2 and compare to all the times in Table 1. The result should be a Y for if the time in table 2 clashes with a time in table 1, and a N if it does not clash.
Attaches is the data, I tried a IF(AND but it doesn't seem to be acknowledging the times correctly and is giving a N when it shouldn't.
Please help!
Bookmarks