Good evening, Here I am hat in hand again.
Picture a group of 4 cells ( let us say A1 A2 B1 B2) could be any group of 4 cells in
range C421....E4:F21....G4:H21....I4:J21....K4:L21 (Not C4:L21)
A1 is the IN time the employee comes to work
A2 is the OUT time
B2 is 0:30 min (Lunch)
I think I need two conditions:
1st condition : If I clear the IN time cell then both OUT and Lunch cells clear also.
2nd condition : If OUT less IN is 4 Hours or less then clear the Lunch cell.
Thank you