Id like to ask for your kind assistance on this, im trying to create an attendance tracker which would determine the employees schedule and the hours he covers,
now will it be possible to automatically fill the the hours by using a formula just by putting the employee schedule under the cst|mnl ?
thank you so much for your help.
MNL | MNL | 12:00 PM | 12:30 PM | 1:00 PM | 1:30 PM | 2:00 PM | 2:30 PM | 3:00 PM | 3:30 PM | 4:00 PM | 4:30 PM | 5:00 PM | 5:30 PM | 6:00 PM | 6:30 PM | 7:00 PM | 7:30 PM | 8:00 PM | 8:30 PM | 9:00 PM | 9:30 PM | 10:00 PM | 10:30 PM | 11:00 PM | 11:30 PM | 12:00 AM | 12:30 AM | 1:00 AM | 1:30 AM | 2:00 AM | 2:30 AM | 3:00 AM | 3:30 AM | 4:00 AM | 4:30 AM | 5:00 AM | 5:30 AM | 6:00 AM | 6:30 AM | 7:00 AM | ||||||
Name | UserID's | Project Role | *Supervisor ID | Name | Region | CST | CST | 0:00 | 0:30 | 1:00 | 1:30 | 2:00 | 2:30 | 3:00 | 3:30 | 4:00 | 4:30 | 5:00 | 5:30 | 6:00 | 6:30 | 7:00 | 7:30 | 8:00 | 8:30 | 9:00 | 9:30 | 10:00 | 10:30 | 11:00 | 11:30 | 12:00 | 12:30 | 13:00 | 13:30 | 14:00 | 14:30 | 15:00 | 15:30 | 16:00 | 16:30 | 17:00 | 17:30 | 18:00 | 18:30 | 19:00 |
A | A | TEAM MEMBER | 321 | A | EMEA | 12:00 PM | 3:30 PM | |||||||||||||||||||||||||||||||||||||||
B | B | TEAM MEMBER | 321 | B | AMER | |||||||||||||||||||||||||||||||||||||||||
C | C | TEAM MEMBER | 321 | C | AMER | |||||||||||||||||||||||||||||||||||||||||
D | D | TEAM MEMBER | 321 | D | AMER | |||||||||||||||||||||||||||||||||||||||||
E | E | TEAM MEMBER | 321 | E | AMER | |||||||||||||||||||||||||||||||||||||||||
F | F | TEAM MEMBER | 321 | F | AMER | |||||||||||||||||||||||||||||||||||||||||
G | G | TEAM MEMBER | 321 | G | EMEA |
<colgroup><col><col><col span="2"><col><col><col span="2"><col span="39"></colgroup><tbody>
</tbody>
https://ibb.co/eRSTKz
Please see the photo thank you so much