Finding Data Out of Range for 5 Consecutive Readings then Reporting the Time it Occurred

Hi,

I am collecting data that is supposed to be within a certain range, lets say 2-8, and I am collecting 1 data point per minute for a long period of time. What I am hoping to do is check to make sure that every data point is within the range, and if it is not within the range for five consecutive minutes have that time be added to a list of out of specification times in a single cell.

The sheet setup is fairly simple A1 would be a column header "TIME" and B1 would be a column header "DATA" and then A2:Axx and B2:Bxx would be the corresponding data. Then in some other cell, let's say D2 it would just be keeping track of any consecutive 5 data points that were not in the 2-8 range of acceptable data. The amount out of spec or any other information is not important, I simply need to know all the times it occurs.

I have attached a sample data sheet which has 30 minutes of sample data, but I will be collecting tens of thousands of data points so combing through the data to find the runs of out of spec data will be incredibly time consuming. There can be extra columns used if necessary, but they have to be hidden, and the more direct the better as I have to validate all of the formulas in the sheet.

I have searched and found formulas using a combination of MAX( and FREQUENCY( to report back if the number of consecutive out of specification cells is >= 5, but along with that I need to know the corresponding time of when that 5+ consecutive data points have occurred.

Any help is appreciated. Thanks so much!