Hello!

I am currently writing work schedules, and my objective is to highlight a row in red if I have someone going to lunch later than 6 hours after they report to work.

Cell A1 contains "10:00 AM", Cell B2 contains "Start Work". Cell A2 contains "3:30 PM", Cell B2 contains "Lunch". But if I were to put "4:30 PM" in Cell A2 instead, I want this row to come up in red (because this is greater than 6 hours after this person's 10:00 AM start).

Does anyone have a conditional formatting solve for this?

Thanks in advance!