Hi Guys,
I have the following attendance sheet report, i want to add in the comments section a display error when someone punch in and doesn't punch out, the issue is that i have multiple columns with time in and time out since they go for breaks during the working hours, so i just want to display the message "Missing punch out" whenever an employee forgets to punch out during anytime from a single day
What formula should i use in Comments?
Thanks a lot,
I have the following attendance sheet report, i want to add in the comments section a display error when someone punch in and doesn't punch out, the issue is that i have multiple columns with time in and time out since they go for breaks during the working hours, so i just want to display the message "Missing punch out" whenever an employee forgets to punch out during anytime from a single day
Emp No. | AC-No. | No. | Date | Clock In 1 | Clock Out 1 | Work Time 1 | Clock In 2 | Clock Out 2 | Work Time 2 | Clock In 3 | Clock Out 3 | Work Time 3 | Clock In 4 | Clock Out 4 | Work Time 4 | Clock In 5 | Clock Out 5 | Work Time 5 | Break Time | Total in time | OT | Under Time | Absent | Comments |
0:00 | 0:00 | 0:00 | 16:00 | 17:44 | 1:43 | 17:59 | 22:00 | 4:00 | 00:17:00 | 5:44 | 1:15 | |||||||||||||
0:00 | 0:00 | 0:00 | 9:30 | 13:03 | 3:33 | 00:00:00 | 3:33 | 3:26 | ||||||||||||||||
0:00 | 0:00 | 0:00 | 15:58 | 19:13 | 3:15 | 19:19 | 22:00 | 2:40 | 00:07:00 | 5:56 | 1:03 | |||||||||||||
0:00 | 0:00 | 0:00 | 15:53 | 22:00 | 6:06 | 00:01:00 | 6:06 | 0:53 | ||||||||||||||||
0:00 | 0:00 | 0:00 | 14:08 | 15:08 | 1:00 | 15:10 | 00:02:00 | TRUE |
What formula should i use in Comments?
Thanks a lot,