Adjusting employees timing file

Hello Everybody,
I want your help in this employees timing file
*I want to delete any duplicates,so every employee has one "in" and one "out" in each day
Or any code or an equation to do the job
*If any employee forget to do "in" or "out" .a new record is created accroding to work system below.
>>>for more details open attachment file
Thank you in advance