Morning to everyone,
I have some trouble to process the worked time of different workers in a month.
Here you have a sample below :
<colgroup><col><col span="13"><col><col><col span="20"><col></colgroup><tbody>
</tbody>
I'd like to process the number of hours worked per worker and per date.
I'd like to take into account night hours(from 21 to 06) and holidays(such as 01/01/2017).
Thanks in advance!
I have some trouble to process the worked time of different workers in a month.
Here you have a sample below :
Week from 12/01 to 12/03 2016 | ||||||||||||||||||||||||||||||||||||
dimanche 27 | lundi 28 | mardi 29 | mercredi 30 | jeudi 01 | vendredi 02 | samedi 03 | ||||||||||||||||||||||||||||||
Shift begining | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | |
Shift end | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | 06 | 13 | 18 | 20 | 00 | |
Worker 1 | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||
Worker 2 | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||
Worker 3 | X | X | X | X | X | X | X | X | X |
<colgroup><col><col span="13"><col><col><col span="20"><col></colgroup><tbody>
</tbody>
I'd like to process the number of hours worked per worker and per date.
I'd like to take into account night hours(from 21 to 06) and holidays(such as 01/01/2017).
Thanks in advance!