Spreadsheet: 842047d1694122568-calculation-of-holiday-hours-holidays-calculator-magalela-2-
Sheet: LucasShift

Month | 2023-08-01 00:00:00
Date | Employee 1 |  |  |  | Employee 2 |  |  |  | Employee 3 |  |  |  |  | Annual Holidays
 | Time In | Time Out | Hours | Holiday Hours | Time  In | Time Out | Hours | Holiday Hours | Time  In | Time Out | Hours | Holiday Hours |  |  | Employee 1 | Employee 2 | Employee 3
 |  |  |  |  | 07:00:00 | 16:16:00 |  |  | 16:00:00 | 07:15:00 |  |  |  | 2023-01-01 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 16:22:00 |  |  | 16:00:00 | 07:19:00 |  |  |  | 2023-04-07 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00 |  |  |  |  |  |  |  | 2023-04-10 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:19:00 |  |  |  |  |  |  |  | 2023-04-19 00:00:00 | 0 | 0 | 0
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00 |  |  |  | 2023-04-25 00:00:00 | 0 | 0 | 0
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00 |  |  |  | 2023-05-01 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:11:00 |  |  |  | 2023-05-18 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:13:00 |  |  |  | 2023-07-22 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:11:00 |  |  |  |  |  |  |  | 2023-08-04 00:00:00 | 9 | 8 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:13:00 |  |  |  |  |  |  |  | 2023-08-06 00:00:00 | 8 | 0 | 9.25
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:12:00 |  |  |  | 2023-08-16 00:00:00 | 9 | 8 | 0
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:19:00 |  |  |  | 2023-08-31 00:00:00 | 0 | 9.25 | 0
 |  |  |  |  | 07:00:00 | 16:12:00 |  |  | 16:00:00 | 07:14:00 |  |  |  | 2023-12-25 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 16:19:00 |  |  | 16:00:00 | 07:17:00 |  |  |  | 2023-12-26 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:14:00 |  |  |  |  |  |  |  | 2023-12-28 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:17:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:24:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:14:00
 |  |  |  |  | 07:00:00 | 16:24:00 |  |  | 16:00:00 | 07:15:00
 |  |  |  |  | 07:00:00 | 16:14:00 |  |  | 16:00:00 | 07:15:00
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:15:00
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:15:00
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
 | 16:00:00 | 07:00:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00
 | 16:00:00 | 07:30:00 |  |  |  |  |  |  | 07:00:00 | 16:15:00
 |  |  |  |  | 07:00:00 | 16:15:00 |  |  | 16:00:00 | 07:15:00
2023-08-04 00:00:00 | from 07.00 to 16.00 = 9 Hours |  |  |  | from 16.00 to 00.00 = 8 Hours |  |  |  | from 16.00 to 00.00 = 8 Hours
2023-08-06 00:00:00 | from 16.00 to 00.00 = 8 Hours |  |  |  | - |  |  |  | -
2023-08-16 00:00:00 | from 07.00 to 16.00 = 9 Hours |  |  |  | from 16.00 to 00.00 = 8 Hours |  |  |  | from 16.00 to 00.00 = 8 Hours
2023-08-31 00:00:00 | from 00.00 to 07.00 = 7 Hours |  |  |  | from 16.00 to 00.00 = 8 Hours |  |  |  | from 16.00 to 00.00 = 8 Hours
 | Total Holidays |  |  |  | Total Holidays |  |  |  | Total Holidays