Checking whether multiple individual dates fall within any date ranges

Hello everyone,

I've been bugged by this problem today and haven't been able to find a solution. I've found another thread on this forum with a very similar problem but I'm not proficient enough in Excel to implement the given solution on my own problem. (http://www.excelforum.com/excel-form...te-ranges.html)

I have three columns. The first one (logtime) contains the date-time a specific measurement was taken in a machine. The second (start) and third (end) columns contain the start and end date-times of when the machine has been shut down. Therefore, I would like to see which measurements were taken while the machine was shut down, as I will remove these from the main data set before moving on to analysis.

I have taken a screenshot of the relevant columns: http://imgur.com/59exMaT

I have also uploaded the worksheet (.xlsx) seen in the screenshot in case anyone would like to download the file and try something out: https://www.dropbox.com/s/xvx2b1i2iwglxns/dat.xlsx?dl=1

Let me know if there is any more information I can provide.

Any help, advice, and solutions will be greatly appreciated. Thanks!

The formula below will identify the relevant rows where the logtimes in Col A were during shutdowns as detailed in Cols B and C. It goes in D2 and copied down.
If the result in D is -1, this means that the logtime in Col A on that row did not occur during a shutdown period. If the result in D is positive, this is the row number
of the shutdown entry that relates to the logtime in Col A.
On that basis, the Logtime in A3 was during a shutdown listed in Row 1 (yellow)
and
The logtimes in A5 and A6 were during the shutdown listed in Row 3 (green)

=SUMPRODUCT(--($B$2:$B$11<=A2)*($C$2:$C$11>=A2),ROW($B$2:$B$11))-1