Calculate work hours

[Tomwhite]

I have techs that work different hours. I will enter their time punches but I need to put a yes or no in a column if they are late, leave early, lunch late, etc.

Tech works M-F 8:00 to 17:00 (Others work 7:00-16:00 and others 9:00 to 18:00 with lunch after 4 hours)

Has 1 hour lunch 12:00 to 13:00 (others 11:00 to 12:00 and others 13:00 to 14:00)

Every other Saturday 9:00 to 14:00 with no lunch

Column D is based on column C. Needs to be Y/N up to 10 minutes late

Column F needs to be Y/N with 30 minutes either way of column E

Column H needs to be Y/N based on less than 70 minutes from column E

Column J needs to be column I with 10 minutes early is ok. No limit beyond

I'd appreciate some help. Thanks

 

[Tomwhite]

After working on this myself this thread is no longer needed and should be deleted if possible.
Thank you,
Tom