Spreadsheet: 844037d1695835894-calculating-meal-penalties-formula-time-exposure-analysis-template
Sheet: Sheet2

Midland Oil Group LLC - Time Audit
WEEK#: |  | START: |  | END: |  |  |  | PAY DATE:
Date | Day | Type | Time In | Time Out | Time In | Time Out | [NAME] | Regular | OT
 | MON |  | 08:00:00 | 13:00:00 | 13:30:00 | 16:57:00 | 08:27:00 | 8:00:00 | 0:27:00
 | TUE |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | WED |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | THU |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | FRI |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SAT |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SUN |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
Regular Rate | 1 |  |  |  |  |  | Total Hours | 2 days, 8:00:00 | 15:27:00 | 2 days, 23:27:00
OT Rate | 1.5 |  |  |  |  |  | Rate Per Hour | 1 | 1.5
 |  |  |  |  |  |  | Total Pay | 56 | 23.18 | 79.18
WEEK#: |  | START: |  | END: |  |  |  | PAY DATE:
Date | Day | Type | Time In | Time Out | Time In | Time Out | [NAME] | Regular | OT
 | MON |  | 08:00:00 | 13:00:00 | 13:30:00 | 16:57:00 | 08:27:00 | 8:00:00 | 0:27:00
 | TUE |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | WED |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | THU |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | FRI |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SAT |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SUN |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
Regular Rate | 1 |  |  |  |  |  | Total Hours | 2 days, 8:00:00 | 15:27:00 | 2 days, 23:27:00
OT Rate | 1.5 |  |  |  |  |  | Rate Per Hour | 1 | 1.5
 |  |  |  |  |  |  | Total Pay | 56 | 23.18 | 79.18
WEEK#: |  | START: |  | END: |  |  |  | PAY DATE:
Date | Day | Type | Time In | Time Out | Time In | Time Out | [NAME] | Regular | OT
 | MON |  | 08:00:00 | 13:00:00 | 13:30:00 | 16:57:00 | 08:27:00 | 8:00:00 | 0:27:00
 | TUE |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | WED |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | THU |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | FRI |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SAT |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SUN |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
Regular Rate | 1 |  |  |  |  |  | Total Hours | 2 days, 8:00:00 | 15:27:00 | 2 days, 23:27:00
OT Rate | 1.5 |  |  |  |  |  | Rate Per Hour | 1 | 1.5
 |  |  |  |  |  |  | Total Pay | 56 | 23.18 | 79.18
WEEK#: |  | START: |  | END: |  |  |  | PAY DATE:
Date | Day | Type | Time In | Time Out | Time In | Time Out | [NAME] | Regular | OT
 | MON |  | 08:00:00 | 13:00:00 | 13:30:00 | 16:57:00 | 08:27:00 | 8:00:00 | 0:27:00
 | TUE |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | WED |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | THU |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | FRI |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SAT |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SUN |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
Regular Rate | 1 |  |  |  |  |  | Total Hours | 2 days, 8:00:00 | 15:27:00 | 2 days, 23:27:00
OT Rate | 1.5 |  |  |  |  |  | Rate Per Hour | 1 | 1.5
 |  |  |  |  |  |  | Total Pay | 56 | 23.18 | 79.18
WEEK#: |  | START: |  | END: |  |  |  | PAY DATE:
Date | Day | Type | Time In | Time Out | Time In | Time Out | [NAME] | Regular | OT
 | MON |  | 08:00:00 | 13:00:00 | 13:30:00 | 16:57:00 | 08:27:00 | 8:00:00 | 0:27:00
 | TUE |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | WED |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | THU |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | FRI |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SAT |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SUN |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
Regular Rate | 1 |  |  |  |  |  | Total Hours | 2 days, 8:00:00 | 15:27:00 | 2 days, 23:27:00
OT Rate | 1.5 |  |  |  |  |  | Rate Per Hour | 1 | 1.5
 |  |  |  |  |  |  | Total Pay | 56 | 23.18 | 79.18
WEEK#: |  | START: |  | END: |  |  |  | PAY DATE:
Date | Day | Type | Time In | Time Out | Time In | Time Out | [NAME] | Regular | OT
 | MON |  | 08:00:00 | 13:00:00 | 13:30:00 | 16:57:00 | 08:27:00 | 8:00:00 | 0:27:00
 | TUE |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | WED |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | THU |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | FRI |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SAT |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
 | SUN |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00 | 10:30:00 | 8:00:00 | 2:30:00
Regular Rate | 1 |  |  |  |  |  | Total Hours | 2 days, 8:00:00 | 15:27:00 | 2 days, 23:27:00
OT Rate | 1.5 |  |  |  |  |  | Rate Per Hour | 1 | 1.5
 |  |  |  |  |  |  | Total Pay | 56 | 23.18 | 79.18