Calculating how many hours taken between shifts

[skoorBmaS]

I have been looking all over the web for something similar to what I am looking for but have not found anything so far which suits what I need.

I am creating a time sheet where colleagues would input data for each employee, where they worked, start time and end time. As part of the law, we have to ensure that an employee has at least a 12 hour break between each shift. Does anyone know any way of doing this?

My data is entered randomly, so unfortunately the employees names are not nessicarily in order. As an example, see below

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Time In[/TD]
[TD]Time Out[/TD]
[/TR]
[TR]
[TD]23/05/2018[/TD]
[TD]Phil[/TD]
[TD]09:00[/TD]
[TD]17:00[/TD]
[/TR]
[TR]
[TD]23/05/2018[/TD]
[TD]Bill[/TD]
[TD]09:00[/TD]
[TD]17:00[/TD]
[/TR]
[TR]
[TD]23/05/2018[/TD]
[TD]Gill[/TD]
[TD]12:00[/TD]
[TD]22:00[/TD]
[/TR]
[TR]
[TD]23/05/2018[/TD]
[TD]Steve[/TD]
[TD]10:00[/TD]
[TD]17:00[/TD]
[/TR]
[TR]
[TD]23/05/2018[/TD]
[TD]Dan[/TD]
[TD]09:00[/TD]
[TD]17:00[/TD]
[/TR]
[TR]
[TD]24/05/2018[/TD]
[TD]Steve[/TD]
[TD]09:00[/TD]
[TD]17:00[/TD]
[/TR]
[TR]
[TD]24/05/2018[/TD]
[TD]Phil[/TD]
[TD]09:00[/TD]
[TD]17:00[/TD]
[/TR]
[TR]
[TD]24/05/2018[/TD]
[TD]Gill[/TD]
[TD]07:00[/TD]
[TD]15:00[/TD]
[/TR]
[TR]
[TD]24/05/2018[/TD]
[TD]Dan[/TD]
[TD]09:00[/TD]
[TD]17:00[/TD]
[/TR]
</tbody>[/TABLE]

So as per the data above, I would like the formula to show that Gill has not had the allocated amount of rest, however I am not sure how to do this with the data being inputted in this way

 

[steve the fish]

Try putting this in E2:

=IF(ISERROR(LOOKUP(2,1/($B$1:B1=B2),$A$1:A1)),"OK",IF(A2+C2-LOOKUP(2,1/($B$1:B1=B2),$A$1:A1+$D$1:D1)>=0.5,"OK","NOT ENOUGH BREAK"))

Edit: It assumes that you input data so that the latest data is at the bottom as shown. This is necessary for it to produce correct results.

 

[skoorBmaS]

Works perfectly, thank you so much