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
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