If function - Too many arguments

Hi, i'm trying to create an if function when employees are getting to and from work.

Basically i have four cells in the same row, first is when shifts starts, second is when employee has clocked in, third is when shift ends, and fourth is when employee has clocked out.
When employees clock in before 8 AM or at most 20 min after 8 AM (lets say 8:16 AM) the fifth cell should write "OK", and when employee clock in at 8:21 AM or later it should be "NOT OK" in the fifth cell.
Almost the same thing is for clocking out, if someone clock out at, lets say 5 PM, or at most 20 min earlier (4:46PM) it should write "OK", but if someone clock out at 4:39PM it should write "NOT OK". If clock in or clock out (or both) cells are empty it should be "NOT OK".
Third (or it's maybe fourth) condition should be, if all four cells are empty, to write "NO SHIFT"
So first two conditions are most important, rest would be good, but not important as the first two.

I have tried something like this, but it returns with too many arguments. I have tried for first two conditions only.

=IF(AND(C6<B6+TIME(0,20,0)),"OK","NOT OK", IF(AND( E6<D6-TIME(0,20,0)),"OK","NOT OK"))

B6 - Shift start
C6 - Clock in time

D6 - Shift ends
E6 - Clock out time


Thanks in advance.

(untested) I think this may be the formula you are looking for...

=IF(C6<B6+TIME(0,20,0),E6>D6-TIME(0,20,0)),"OK","NOT OK")

Note: I made E6 greater than D6-TIME(0,20,0), not less than as you have it... I think that is correct.

already answered while i was typing.

Thank you so much, you were all correct, but 6StringJazzer has solved everything i've had in mind I have just forgot one more thing, there is one more cell (A6), and i need to add that part in IF(B6&C6&D6&E6="","NO SHIFT", so if A6 is empty, and B6, C6, D6, E6 are also empty, then it should write "NO SHIFT", but if there is some value in A6, but other four cells are empty, it should write "ON LEAVE". I have tried to add one more IF OR, but it's not working.

Wow, i did a quick test too, and it looks like it's exactly what i had in mind. Thank you very much!

Originally Posted by 6StringJazzer

Let's try this. Did a quick test.

Formula:

Please Login or Register  to view this content.

Me again, i have noticed one problem, when C6 is empty (A6, B6, E6, D6 have some value) i get "OK", but when E6 is empty (A6, B6, C6, D6 have some value) i get "NOT OK", and i should get "NOT OK" for both. So basically only C6 is a problem, but i don't have a clue how to solve it, and why i get OK for first and NOT OK for second.

Sure i can, i have made a sample of excel file, i have added all cells, and if function also. I have marked that cell with red color.
So, when somebody forget to Clock Out, everything is ok, i get "NOT OK", but when somebody forget to Clock In, i get "OK", but i should get "NOT OK".

Thanks for your help

What can i say, thank you so much once more You can send me your paypal if you want, i would like to buy you a coffee, or a beer