Hi everyone,


I have this file of attendance that can compute for tardiness and under time. My question is how can I subtract the unpaid break to his/her working hours? The working hours is 8:30 am to 5:30 PM. The unpaid break is from 12:30 pm to 1:30 pm. so far what I have come up with the formula is this:

=IF(B9=0,"",IF(OR(WEEKDAY(A9)=1,WEEKDAY(A9)=7,$S$6="",B9<=$S$6,B9<=G9,B9<=J9,B9<=M9,B9<=P9),0,B9-$S$6))

and this one;

=IF(C9=0,"",IF(OR(WEEKDAY(A9)=1,WEEKDAY(A9)=7,$T$6="",C9>=$T$6,C9<=H9,C9<=K9,C9<=N9,C9<=Q9),0,$T$6-C9))

Thanks in advance.