Spreadsheet: 842476d1694548345-calculation-of-holiday-hours-holidays-calculator-magalela-2-lunch-break
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 | 17:00:00 |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-01-01 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-04-07 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  |  |  |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-04-10 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  |  |  |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-04-19 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  |  |  |  |  |  | 2023-04-25 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  |  |  |  |  |  | 2023-05-01 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-05-18 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-07-22 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  |  |  |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-08-04 00:00:00 | 9 | 8 | 0
 | 07:00:00 | 16:00:00 |  |  |  |  |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-08-06 00:00:00 | 8 | 0 | 9.25
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  |  |  |  |  |  | 2023-08-16 00:00:00 | 9 | 8 | 0
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  |  |  |  |  |  | 2023-08-31 00:00:00 | 0 | 9.25 | 0
 |  |  |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-12-25 00:00:00 | 0 | 0 | 0
 |  |  |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-12-26 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  |  |  |  |  | 06:00:00 | 17:15:00 |  |  |  | 2023-12-28 00:00:00 | 0 | 0 | 0
 | 07:00:00 | 16:00:00 |  |  |  |  |  |  | 06:00:00 | 17:15:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00
 |  |  |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00
 |  |  |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00
 | 07:00:00 | 16:00:00 |  |  |  |  |  |  | 06:00:00 | 17:15:00
 | 07:00:00 | 16:00:00 |  |  |  |  |  |  | 06:00:00 | 17:15:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17:15:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00
 | 07:00:00 | 16:00:00 |  |  | 07:00:00 | 17:00:00 |  |  | 06:00:00 | 17: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