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.
[TABLE="width: 1369"]
<colgroup><col><col><col span="2"><col><col><col span="2"><col span="39"></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MNL[/TD]
[TD]MNL[/TD]
[TD]12:00 PM[/TD]
[TD]12:30 PM[/TD]
[TD]1:00 PM[/TD]
[TD]1:30 PM[/TD]
[TD]2:00 PM[/TD]
[TD]2:30 PM[/TD]
[TD]3:00 PM[/TD]
[TD]3:30 PM[/TD]
[TD]4:00 PM[/TD]
[TD]4:30 PM[/TD]
[TD]5:00 PM[/TD]
[TD]5:30 PM[/TD]
[TD]6:00 PM[/TD]
[TD]6:30 PM[/TD]
[TD]7:00 PM[/TD]
[TD]7:30 PM[/TD]
[TD]8:00 PM[/TD]
[TD]8:30 PM[/TD]
[TD]9:00 PM[/TD]
[TD]9:30 PM[/TD]
[TD]10:00 PM[/TD]
[TD]10:30 PM[/TD]
[TD]11:00 PM[/TD]
[TD]11:30 PM[/TD]
[TD]12:00 AM[/TD]
[TD]12:30 AM[/TD]
[TD]1:00 AM[/TD]
[TD]1:30 AM[/TD]
[TD]2:00 AM[/TD]
[TD]2:30 AM[/TD]
[TD]3:00 AM[/TD]
[TD]3:30 AM[/TD]
[TD]4:00 AM[/TD]
[TD]4:30 AM[/TD]
[TD]5:00 AM[/TD]
[TD]5:30 AM[/TD]
[TD]6:00 AM[/TD]
[TD]6:30 AM[/TD]
[TD]7:00 AM[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]UserID's[/TD]
[TD]Project Role[/TD]
[TD]*Supervisor ID[/TD]
[TD]Name[/TD]
[TD]Region[/TD]
[TD]CST[/TD]
[TD]CST[/TD]
[TD]0:00[/TD]
[TD]0:30[/TD]
[TD]1:00[/TD]
[TD]1:30[/TD]
[TD]2:00[/TD]
[TD]2:30[/TD]
[TD]3:00[/TD]
[TD]3:30[/TD]
[TD]4:00[/TD]
[TD]4:30[/TD]
[TD]5:00[/TD]
[TD]5:30[/TD]
[TD]6:00[/TD]
[TD]6:30[/TD]
[TD]7:00[/TD]
[TD]7:30[/TD]
[TD]8:00[/TD]
[TD]8:30[/TD]
[TD]9:00[/TD]
[TD]9:30[/TD]
[TD]10:00[/TD]
[TD]10:30[/TD]
[TD]11:00[/TD]
[TD]11:30[/TD]
[TD]12:00[/TD]
[TD]12:30[/TD]
[TD]13:00[/TD]
[TD]13:30[/TD]
[TD]14:00[/TD]
[TD]14:30[/TD]
[TD]15:00[/TD]
[TD]15:30[/TD]
[TD]16:00[/TD]
[TD]16:30[/TD]
[TD]17:00[/TD]
[TD]17:30[/TD]
[TD]18:00[/TD]
[TD]18:30[/TD]
[TD]19:00[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A[/TD]
[TD]TEAM MEMBER[/TD]
[TD]321[/TD]
[TD]A[/TD]
[TD]EMEA[/TD]
[TD]12:00 PM[/TD]
[TD]3:30 PM[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]B[/TD]
[TD]TEAM MEMBER[/TD]
[TD]321[/TD]
[TD]B[/TD]
[TD]AMER[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]C[/TD]
[TD]TEAM MEMBER[/TD]
[TD]321[/TD]
[TD]C[/TD]
[TD]AMER[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]D[/TD]
[TD]TEAM MEMBER[/TD]
[TD]321[/TD]
[TD]D[/TD]
[TD]AMER[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]E[/TD]
[TD]TEAM MEMBER[/TD]
[TD]321[/TD]
[TD]E[/TD]
[TD]AMER[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]F[/TD]
[TD]TEAM MEMBER[/TD]
[TD]321[/TD]
[TD]F[/TD]
[TD]AMER[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]G[/TD]
[TD]TEAM MEMBER[/TD]
[TD]321[/TD]
[TD]G[/TD]
[TD]EMEA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
https://ibb.co/eRSTKz
Please see the photo thank you so much
