Hi all, I'm trying to do something fairly simple in logic but difficult in Excel.
I have data that has dates, times & job codes. I want to trigger a yes or no response to the question does date XYZ have the required job code. I want to create simple table with dates in column A and job codes in the B, C & D columns that will tell me YES or NO if the job code is present on a certain day for AM or PM time slots. Based on the data in the mini sheet, I want to build a table that will tell me if I had the BUSSER job code in the AM (prior to 5pm) or the PM (after 5pm) time slot.
This is what the table would look like based on the data above:
Any help would be appreciated. Thanks in advance!
I have data that has dates, times & job codes. I want to trigger a yes or no response to the question does date XYZ have the required job code. I want to create simple table with dates in column A and job codes in the B, C & D columns that will tell me YES or NO if the job code is present on a certain day for AM or PM time slots. Based on the data in the mini sheet, I want to build a table that will tell me if I had the BUSSER job code in the AM (prior to 5pm) or the PM (after 5pm) time slot.
PP25-2021 Reuben's (2020-11-29 to 2021-12-12).xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
B | C | D | F | G | H | ||||
1 | Date | First | Last | In Time | Out Time | Role | |||
5 | Tue-30-Nov-21 | Wayne | Paul | 11:00AM | 5:07PM | BARTENDER | |||
10 | Tue-30-Nov-21 | Justin | Brassard | 11:00AM | 2:23PM | GREETER | |||
14 | Tue-30-Nov-21 | Shishir | Shekh | 11:06AM | 4:58PM | BUSSER | |||
15 | Tue-30-Nov-21 | Tali | Treister | 11:30AM | 6:47PM | GREETER | |||
27 | Tue-30-Nov-21 | Abigaelle | Vasseur | 4:25PM | 10:04PM | GREETER | |||
32 | Tue-30-Nov-21 | Stephanie | Carter | 5:05PM | 10:35PM | BARTENDER | |||
42 | Wed-1-Dec-21 | Justin | Brassard | 11:00AM | 5:00PM | GREETER | |||
45 | Wed-1-Dec-21 | Danny | Chin | 11:05AM | 4:59PM | BARTENDER | |||
47 | Wed-1-Dec-21 | Shishir | Shekh | 11:18AM | 4:58PM | BUSSER | |||
59 | Wed-1-Dec-21 | Genevieve | Turgeon | 5:00PM | 10:33PM | BARTENDER | |||
60 | Wed-1-Dec-21 | Daniel-Dominik | Dumont | 5:00PM | 11:15PM | BUSSER | |||
Punch Report |
This is what the table would look like based on the data above:
PP25-2021 Reuben's (2020-11-29 to 2021-12-12).xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | AM | PM | |||||||
2 | Date | BUSSER | GREETER | BARTENDER | BUSSER | GREETER | BARTENDER | ||
3 | 11/30/21 | YES | YES | YES | NO | YES | YES | ||
4 | 12/01/21 | YES | YES | YES | YES | NO | YES | ||
Sheet1 |
Any help would be appreciated. Thanks in advance!