Highlight when a time does not meet a set time

[Flopem123]

Morning

I have a timesheet which is used by around 15 people and I want to ensure people are taking the correct amount of time for lunch.

By law people need to take a break of 20 minutes and I would like to highlight too people if their break is below this legal limit.

One of the problems I have is that people clock in and out multiple times during the day for 5 or 10 minutes but they must have a 20 minute break if working over 6 hours.

Day	In	Out	In2	Out3	In4	Out5	In6	Out7	In3	Out4	Hours Worked
Monday	08:10	10:10	10:20	12:00	12:15	16:00					07:25
Tuesday	06:30	07:30	10:20	12:00	12:15	18:00					08:25
Wednesday	08:10	10:10	10:20	12:00	12:15	16:00					07:25
Thursday	08:10	10:10	10:20	12:00	12:15	16:00					07:25
Friday	08:10	10:10	10:20	12:00	12:15	16:00					07:25
Saturday											00:00
Sunday											00:00
								Total Hours worked this week	38:05

The above is just an example of someone who may not take the correct time for lunch and ensure they have a 20 minute break every 6 hours they work on that day.

Is there a simple solution to highlight the Hours worked cell if there is no gap of 20 minutes?

Thanks

 

[6StringJazzer]

Your In and Out column headings seem to be out of order--is that what they really look like, or is a copy error?

 

[Flopem123]

They are out but it doesn't cause any problems that I know, The formula is all over the place but as it seems to be working I'm reluctant to change it at the moment, I also have loads of numbers after each timesheet but I think it due to have multiple sheets. I will probably fix it when I get some time

=TimeSheet334567891012131415161718[@Out]-TimeSheet334567891012131415161718[@In]+TimeSheet334567891012131415161718[@Out3]-TimeSheet334567891012131415161718[@In2]+TimeSheet334567891012131415161718[@Out5]-TimeSheet334567891012131415161718[@In4]+TimeSheet334567891012131415161718[@Out7]-TimeSheet334567891012131415161718[@In6]+TimeSheet334567891012131415161718[@Out4]-TimeSheet334567891012131415161718[@In3]