I need help figuring out a formula. In this example: Column E is Start and F is Finish. I want to write a formula in column J that writes an "X" with the following conditions:
- E > 7:00 a.m.
- The time difference between F with the last "X" written and the next E is at least 30 min. (F has to be before E).
In the example shown only J15 and J22 need to have an "X" but can't figure out how to write the formula (ignore "#N/A" in J16).