Conditional Formatting Using MOD and AND formulas

I didn't download your files.

After reading the top post again I think I have misunderstood what you want to do.

Originally Posted by Harrytheb

Eg
Start Stop Hrs Worked
08:00 21:00 12:00
03:00 09:00 06:00

In the example I am trying to get 03:00 go red on condition it is less than 8hrs between the stop time 21:00 and 03:00 start time.

So, it's based on the stop time from the row above and the start time from the row below? Is that correct?

Based on the Harrytheb2.xlsx file...

Select the range B11:B19 starting from B11.

Conditional formatting
Formula:

=AND(COUNT(H10,B11)=2,MOD(B11-H10,1)<TIME(8,0,0))