Monthly Recap (Work Hours)
| PERSON ID | NAME | TOTAL | JAM LEBIH | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No data for the selected month/filters. | ||||||||||||||||||||||||||||||||||
Calculation: For each day, hours = latest MACHINE_OUT minus earliest MACHINE_IN.
“JAM LEBIH” = TOTAL − expected hours. Expected hours are based on either:
Weekdays (Mon–Fri) minus holidays from the holidays table