Spreadsheet: 78728d1279050999-if-and-statement-should-0-instead-of-true-electronic-timesheets-071310
Sheet: Bargaining Time Sheet

Sheriff's Bargaining Unit Timesheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supervisor |  | # of Hours |  | TOD | Shifts | TOD | Date | TOD
Employee Name: |  |  |  |  |  |  | Pay Period Dates (mm/dd/yy) |  |  |  |  |  |  |  |  | Scheduled Hours |  |  |  | 00:00:00 | 1 | 00:00:00 | 1 | 00:00:00
Employee Number: |  |  |  |  |  |  | Beginning: |  |  |  | Ending: |  |  |  |  | Overtime Hours |  |  |  | 00:15:00 | 2 | 00:15:00 | 2 | 03:00:00
 | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat |  |  | ST |  | 0 |  | 00:30:00 | 3 | 00:30:00 | 3 | 07:00:00
In | 00:00:00 | 3 | FamSick | 3 | 00:00:00 | 3 | FamSick | 3 | Days Off |  | Days Off |  | Days Off |  |  | ST Training |  |  |  | 00:45:00 | OT1 | 00:45:00 | 4 | 11:00:00
Out | 07:00:00 |  |  |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  | Doubletime Hours |  | 0 |  | 01:00:00 | OT2 | 01:00:00 | 5 | 15:00:00
In | 07:00:00 | OT3 |  |  | 07:00:00 | OT3 |  |  |  |  |  |  |  |  |  | Shift 2 Differential |  |  |  | 01:15:00 | OT3 | 01:15:00 | 6 | 19:00:00
Out | 11:00:00 |  |  |  | 11:00:00 |  |  |  |  |  |  |  |  |  |  | Shift 2 Differential OT |  |  |  | 01:30:00 |  | 01:30:00 | 7 | 23:00:00
In | FamSick | 3 | 23:00:00 | 3 | FamSick | 3 | Days Off |  | Days Off |  | Days Off |  | 23:00:00 | 3 |  | Shift 3 Differential |  |  |  | 01:45:00 |  | 01:45:00 | 8 | 00:00:00
Out |  |  | 00:00:00 |  |  |  |  |  |  |  |  |  | 00:00:00 |  |  | Shift 3 Differential OT |  |  |  | 02:00:00 |  | 02:00:00 | 9 | 00:15:00
Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taxable F.B. |  | 0 |  | 02:15:00 |  | 02:15:00 | 10 | 00:30:00
Scheduled | 8 |  | 8 |  | 8 |  | 7 |  | 0 |  | 0 |  | 1 |  |  | Comp Time Earned |  |  |  | 02:30:00 |  | 02:30:00 | 11 | 00:45:00
 | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat |  |  | Comp Time Used |  |  |  | 02:45:00 | Select Other > | 02:45:00 | 12 | 01:00:00
In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation Used |  |  |  | 03:00:00 | Military Leave | 03:00:00 | 13 | 01:15:00
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick Used |  |  |  | 03:15:00 | Straight Time Training | 03:15:00 | 14 | 01:30:00
In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Family Sick Used |  |  |  | 03:30:00 | Wellness Used | 03:30:00 | 15 | 01:45:00
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal Days Used |  |  |  | 03:45:00 |  | 03:45:00 | 16 | 02:00:00
In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 04:00:00 |  | 04:00:00 | 17 | 02:15:00
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:15:00 |  | 04:15:00 | 18 | 02:30:00
Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:30:00 |  | 04:30:00 | 19 | 02:45:00
Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other: |  |  |  | 04:45:00 |  | 04:45:00 | 20 | 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:00:00 |  | 05:00:00 | 21 | 03:15:00
Category |  |  | Shift 1 |  | Shift 2 |  | Shift 3 |  | Totals |  |  | I certify the above to be an accurate and correct statement of hours worked for this pay period. |  |  |  |  |  |  |  | 05:15:00 |  | 05:15:00 | 22 | 03:30:00
Regular Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:30:00 |  | 05:30:00 | 23 | 03:45:00
Overtime Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:45:00 |  | 05:45:00 | 24 | 04:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Employee Signature |  |  |  |  |  |  |  | 06:00:00 |  | 06:00:00 | 25 | 04:15:00
Family Sick Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:15:00 |  | 06:15:00 | 26 | 04:30:00
Comp Used |  |  |  |  |  |  |  |  |  |  |  | Supervisor Signature |  |  |  |  |  |  |  | 06:30:00 |  | 06:30:00 | 27 | 04:45:00
Vacation Used |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:45:00 |  | 06:45:00 | 28 | 05:00:00
Funeral Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  | 07:00:00 | 29 | 05:15:00
Personal Days |  |  |  |  |  |  |  |  |  |  |  | Date Paid  __________     Gross Pay __________ |  |  |  |  |  |  |  | 07:15:00 |  | 07:15:00 | 30 | 05:30:00
Select Other > |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 |  | 07:30:00 | 31 | 05:45:00
Select Other > |  |  |  |  |  |  |  |  |  |  |  | Flex Cash  __________     Warrant #  __________ |  |  |  |  |  |  |  | 07:45:00 |  | 07:45:00 |  | 06:00:00
Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  | 08:00:00 |  | 06:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:15:00 |  | 08:15:00 |  | 06:30:00
Regular Time & Shift Differential Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 |  | 08:30:00 |  | 06:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:45:00 |  | 08:45:00 |  | 07:00:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 |  | 09:00:00 |  | 07:15:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:15:00 |  | 09:15:00 |  | 07:30:00
Worked Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 |  | 09:30:00 |  | 07:45:00
Sched Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:45:00 |  | 09:45:00 |  | 08:00:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  | 10:00:00 |  | 08:15:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:15:00 |  | 10:15:00 |  | 08:30:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 |  | 10:30:00 |  | 08:45:00
Worked Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:45:00 |  | 10:45:00 |  | 09:00:00
Sched Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 |  | 11:00:00 |  | 09:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:15:00 |  | 11:15:00 |  | 09:30:00
Overtime & Overtime Differential Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 |  | 11:30:00 |  | 09:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:45:00 |  | 11:45:00 |  | 10:00:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  | 12:00:00 |  | 10:15:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:15:00 |  | 12:15:00 |  | 10:30:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00 |  | 12:30:00 |  | 10:45:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:45:00 |  | 12:45:00 |  | 11:00:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 |  | 13:00:00 |  | 11:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:15:00 |  | 13:15:00 |  | 11:30:00
ST Training Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 |  | 13:30:00 |  | 11:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:45:00 |  | 13:45:00 |  | 12:00:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 |  | 14:00:00 |  | 12:15:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:15:00 |  | 14:15:00 |  | 12:30:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 |  | 14:30:00 |  | 12:45:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:45:00 |  | 14:45:00 |  | 13:00:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 |  | 15:00:00 |  | 13:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:15:00 |  | 15:15:00 |  | 13:30:00
Miscellaneous 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 |  | 15:30:00 |  | 13:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:45:00 |  | 15:45:00 |  | 14:00:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 |  | 16:00:00 |  | 14:15:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:15:00 |  | 16:15:00 |  | 14:30:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00 |  | 16:30:00 |  | 14:45:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:45:00 |  | 16:45:00 |  | 15:00:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00 |  | 17:00:00 |  | 15:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00 |  | 17:15:00 |  | 15:30:00
Sick Time Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 |  | 17:30:00 |  | 15:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:45:00 |  | 17:45:00 |  | 16:00:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 |  | 18:00:00 |  | 16:15:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:15:00 |  | 18:15:00 |  | 16:30:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:30:00 |  | 18:30:00 |  | 16:45:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 |  | 18:45:00 |  | 17:00:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 |  | 19:00:00 |  | 17:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:15:00 |  | 19:15:00 |  | 17:30:00
Vacation Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00 |  | 19:30:00 |  | 17:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:45:00 |  | 19:45:00 |  | 18:00:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 |  | 20:00:00 |  | 18:15:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:15:00 |  | 20:15:00 |  | 18:30:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00 |  | 20:30:00 |  | 18:45:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:45:00 |  | 20:45:00 |  | 19:00:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 |  | 21:00:00 |  | 19:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:15:00 |  | 21:15:00 |  | 19:30:00
Family Sick Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00 |  | 21:30:00 |  | 19:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:45:00 |  | 21:45:00 |  | 20:00:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 |  | 22:00:00 |  | 20:15:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:15:00 |  | 22:15:00 |  | 20:30:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:30:00 |  | 22:30:00 |  | 20:45:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:45:00 |  | 22:45:00 |  | 21:00:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  | 23:00:00 |  | 21:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:15:00 |  | 23:15:00 |  | 21:30:00
Compensatory Time Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00 |  | 23:30:00 |  | 21:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:45:00 |  | 23:45:00 |  | 22:00:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  | Trade |  | 22:15:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal |  |  |  | 22:30:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comp |  |  |  | 22:45:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wellness |  |  |  | 23:00:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  |  | 23:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FamSick |  |  |  | 23:30:00
Funeral Leave Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Military |  |  |  | 23:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Funeral |  |  |  | Vacation
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | School |  |  |  | Personal
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training |  |  |  | Comp
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST Training |  |  |  | Wellness
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid |  |  |  | Sick
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trade |  |  |  | FamSick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days Off |  |  |  | Military
Personal Time Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Funeral
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | School
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST Train
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trade
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Retreat
Wellness Days Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days Off
1st Shift
2nd Shift
3rd Shift
1st Shift
2nd Shift
3rd Shift
Military Time Computation
1st Shift
2nd Shift
3rd Shift
1st Shift
2nd Shift
3rd Shift
Unpaid Time Off Computation
1st Shift
2nd Shift
3rd Shift
1st Shift
2nd Shift
3rd Shift
Sick Time Summary Computation: Shift 1
Week 1
Week 2
Sick Time Summary Computation: Shift 2
Week 1
Week 2
Sick Time Summary Computation: Shift 3
Week 1
Week 2
Family Sick Time Summary Computation: Shift 1
Week 1
Week 2
Family Sick Time Summary Computation: Shift 2
Week 1
Week 2
Family Sick Time Summary Computation: Shift 3
Week 1
Week 2
Comp Time Summary Computation: Shift 1
Week 1
Week 2
Comp Time Summary Computation: Shift 2
Week 1
Week 2
Comp Time Summary Computation: Shift 3
Week 1
Week 2
Vacation Summary Computation: Shift 1
Week 1
Week 2
Vacation Summary Computation: Shift 2
Week 1
Week 2
Vacation Summary Computation: Shift 3
Week 1
Week 2
Funeral Summary Computation: Shift 1
Week 1
Week 2
Funeral Summary Computation: Shift 2
Week 1
Week 2
Funeral Summary Computation: Shift 3
Week 1
Week 2
Personal Time Summary Computation: Shift 1
Week 1
Week 2
Personal Time Summary Computation: Shift 2
Week 1
Week 2
Personal Time Summary Computation: Shift 3
Week 1
Week 2
Military Leave Summary Computation: Shift 1
Week 1
Week 2
Military Leave Summary Computation: Shift 2
Week 1
Week 2
Military Leave Summary Computation: Shift 3
Week 1
Week 2
Straight Time Training Summary Computation: Shift 1
Week 1
Week 2
Straight Time Training Summary Computation: Shift 2
Week 1
Week 2
Straight Time Training Summary Computation: Shift 3
Week 1
Week 2
Wellness Time Summary Computation: Shift 1
Week 1
Week 2
Wellness Time Summary Computation: Shift 2
Week 1
Week 2
Wellness Time Summary Computation: Shift 3
Week 1
Week 2