Break Schedule - same shift , stagger breaks

Hi Ron,

I'll get back to you later.

Pete

Try these formulae in the cells stated:

E2: =IF(OR(COUNTIF(B2:C2,""),COUNTIF(B2:C2,"OFF")),"",B2+TIME(1,30,0)+COUNTIF($B$1:B1,B2)*TIME(0,15,0))

F2: =IF(E2="","",IF(D2 < TIME(5,0,0),"---",B2+TIME(4,0,0)+COUNTIF(B$1:B1,B2)*TIME(0,30,0)))

G2: =IF(E2="","",IF(D2 < TIME(7,0,0),"---",C2-TIME(2,0,0)+COUNTIF(B$1:B1,B2)*TIME(0,15,0)))

then copy down as required.

Hope this helps.

Pete

Pete, you are an excel genius. !

Thanks for the kind words - glad to help.

Pete