Possible conditional formatting solution??

OliverScheurich 

The conditional formatting did work. I attached my Excel document. I also copy and pasted some of the data. Are you entering the formula in column H at the start of the data? When I go to enter that formula, only the first column returns 1 despite the rows beneath it being highlighted.

In the attached Table 1 below, the column labeled "MAX" is what I used the conditional formatting to highlight the boxes that are blank and <10. When I entered the formula you gave me, I noticed that it isn't giving me the date and start time followed by the end time of the last highlighted box. For example, since cell 33 is <10 and highlighted (in this case I couldn't highlight, so I changed the font to red), the date and start I need the formula to output is 2022/12/31 23:58:00 with the end time being cell 443 because it ends after the last data value in cell 442, so the end time or stop time I need is 2023/01/01 13:38:00. Right after, there is a Gap time, so I need to do the same thing. In this example, the Gap also starts at cell 443, so the start time is 

with a stop time of 

If possible, I would like to be able to have a code that writes GAP off to the side as seen in the second table, but that isn't urgent.

The third time interval occurs right after the GAP in this particular dataset, so I would write the start time of 

and the end time of 

Based on the formula you gave me, I tried tweaking it to: =IF(OR(AND(AND(E33<>"",E33<10)=TRUE,AND(E32<>"",E32<10)=FALSE),AND(NOT(ISBLANK(E33)),AND(E33<>"",E33<10)=FALSE,AND(E32<>"",E32<10)=TRUE)),1,""), however this did not work. Hopefully my explanation makes sense. I have to do the same thing for column M with conditional formatting and the formula as well. 

Also, thank you so much for your time and help thus far! 

Table 1

Table 2