Spreadsheet: 559739d1517850403-formula-to-calculate-hours-worked-w-lunch-or-w-o-ot-column-only-total-after-40-hours-airport-wk-end-000000
Sheet: Template

BROWRW0507 |  | Name: [NAME], [NAME] |  |  |  | Dept: 87-50 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Vac | [NAME] | Holiday
2/4 | SUN | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/5 | MON | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/6 | TUE | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/7 | WED | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/8 | THU | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/9 | FRI | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/10 | SAT | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/11 | SUN | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/12 | MON | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/13 | TUE | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/14 | WED | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/15 | THU | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/16 | FRI | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/17 | SAT | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | Totals | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 0 | Overtime (hrs) |  | 0 | Vacation |  | 0 | [NAME] |  | 0 | Holiday | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
LAFOJR0615 |  | Name: LaFountain, [NAME] |  |  |  | Dept: 87-50 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Vac | [NAME] | Holiday
2/4 | SUN | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/5 | MON | 07:00:00 | 15:15:00 |  |  |  |  |  |  | 12 | 0 |  |  |  |  |  | 8.249999999999998 | 0
2/6 | TUE | 07:00:00 | 15:00:00 |  |  |  |  |  |  | 12 | 0
2/7 | WED | 06:00:00 | 09:00:00 |  |  |  |  |  |  | 3 | 0
2/8 | THU | 07:00:00 | 15:00:00 |  |  |  |  |  |  | 12 | 0
2/9 | FRI | 07:00:00 | 15:00:00 |  |  |  |  |  |  | 12 | 0
2/10 | SAT | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/11 | SUN | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/12 | MON | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/13 | TUE | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/14 | WED | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/15 | THU | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/16 | FRI | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/17 | SAT | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | Totals | 51 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 51 | Overtime (hrs) |  | 0 | Vacation |  | 0 | [NAME] |  | 0 | Holiday | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
MILLRE0510 |  | Name: Mills, [NAME] |  |  |  | Dept: 87-50 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Vac | [NAME] | Holiday
2/4 | SUN | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/5 | MON | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/6 | TUE | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/7 | WED | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/8 | THU | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/9 | FRI | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/10 | SAT | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/11 | SUN | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/12 | MON | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/13 | TUE | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/14 | WED | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/15 | THU | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/16 | FRI | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
2/17 | SAT | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | Totals | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 0 | Overtime (hrs) |  | 0 | Vacation |  | 0 | [NAME] |  | 0 | Holiday | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
TURNET1008 |  | Name: Turner, Eddy |  |  |  | Dept: 87-50 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Vac | [NAME] | Holiday
2/4 | SUN | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/5 | MON | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/6 | TUE | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/7 | WED | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/8 | THU | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/9 | FRI | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/10 | SAT | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/11 | SUN | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/12 | MON | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/13 | TUE | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/14 | WED | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/15 | THU | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/16 | FRI | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/17 | SAT | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | Totals | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 0 | Overtime (hrs) |  | 0 | Vacation |  | 0 | [NAME] |  | 0 | Holiday | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
 |  | Name: |  |  |  | Dept: 87-50 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Vac | [NAME] | Holiday
2/4 | SUN
2/5 | MON | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/6 | TUE | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/7 | WED | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/8 | THU | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/9 | FRI | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/10 | SAT | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/11 | SUN | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/12 | MON | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/13 | TUE | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/14 | WED | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/15 | THU | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/16 | FRI | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 0
2/17 | SAT
 |  |  |  |  |  |  |  |  | Totals | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 0 | Overtime (hrs) |  | 0 | Vacation |  | 0 | [NAME] |  | 0 | Holiday | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date: