Spreadsheet: 77529d1277988338-if-statement-electronic-timesheets-070110
Sheet: Bargaining Time Sheet

Sheriff's Bargaining Unit Timesheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supervisor |  | # of Hours |  | TOD | Shifts | TOD
Employee Name: |  |  |  |  |  |  | Pay Period Dates (mm/dd/yy) |  |  |  |  |  |  |  |  | Scheduled Hours |  | 0 |  | 1900-01-01 00:00:00 | 1 | 1900-01-01 00:00:00
Employee Number: |  |  |  |  |  |  | Beginning: |  |  |  | Ending: |  |  |  |  | Overtime Hours |  |  |  | 00:15:00 | 2 | 00:15:00
 | Sun | 25 | Mon | 26 | Tue | 27 | Wed | 28 | Thu | 29 | Fri | 30 | Sat | 1 |  | ST |  | 0 |  | 00:30:00 | 3 | 00:30:00
In | 07:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | ST Training |  | 0 |  | 00:45:00 |  | 00:45:00
Out | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST Canine |  | 0 |  | 01:00:00 |  | 01:00:00
In | Sick | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Doubletime Hours |  | 0 |  | 01:15:00 |  | 01:15:00
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift 2 Differential |  | 0 |  | 01:30:00 |  | 01:30:00
In | 13:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift 2 Differential OT |  | 0 |  | 01:45:00 |  | 01:45:00
Out | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift 3 Differential |  | 0 |  | 02:00:00 |  | 02:00:00
Worked | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | Shift 3 Differential OT |  | 0 |  | 02:15:00 |  | 02:15:00
Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taxable F.B. |  | 0 |  | 02:30:00 |  | 02:30:00
 | Sun | 2 | Mon | 3 | Tue | 4 | Wed | 5 | Thu | 6 | Fri | 7 | Sat | 8 |  | Comp Time Earned |  |  |  | 02:45:00 |  | 02:45:00
In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comp Time Used |  | 0 |  | 03:00:00 |  | 03:00:00
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation Used |  | 0 |  | 03:15:00 |  | 03:15:00
In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick Used |  | 0 |  | 03:30:00 |  | 03:30:00
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Family Sick Used |  | 0 |  | 03:45:00 |  | 03:45:00
In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal Days Used |  | 0 |  | 04:00:00 |  | 04:00:00
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Military Leave |  | 0 |  | 04:15:00 |  | 04:15:00
Worked | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | [NAME] |  |  |  | 04:30:00 |  | 04:30:00
Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other: |  |  |  | 04:45:00 |  | 04:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:00:00 |  | 05:00: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
Regular Hours |  |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | 05:30:00 |  | 05:30:00
Overtime Hours |  |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | 05:45:00 |  | 05:45:00
[NAME] |  |  |  |  |  |  |  |  | 0 |  |  | Employee Signature |  |  |  |  |  |  |  | 06:00:00 |  | 06:00:00
Family Sick Leave |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 06:15:00 |  | 06:15:00
Comp Used |  |  |  |  |  |  |  |  | 0 |  |  | Supervisor Signature |  |  |  |  |  |  |  | 06:30:00 |  | 06:30:00
Vacation Used |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 06:45:00 |  | 06:45:00
Funeral Leave |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  | 07:00:00
Personal Days |  |  |  |  |  |  |  |  | 0 |  |  | Date Paid  __________     Gross Pay __________ |  |  |  |  |  |  |  | 07:15:00 |  | 07:15:00
Wellness |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 07:30:00 |  | 07:30:00
Military Leave |  |  |  |  |  |  |  |  | 0 |  |  | Flex Cash  __________     Warrant #  __________ |  |  |  |  |  |  |  | 07:45:00 |  | 07:45:00
Totals |  |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  | 08:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:15:00 |  | 08:15:00
Shift Differential Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 |  | 08:30:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 08:45:00 |  | 08:45:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 09:00:00 |  | 09:00:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 09:15:00 |  | 09:15:00
Worked Hrs | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  | 09:30:00 |  | 09:30:00
Sched Hrs | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  | 09:45:00 |  | 09:45:00
1st Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 10:00:00 |  | 10:00:00
2nd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 10:15:00 |  | 10:15:00
3rd Shift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 10:30:00 |  | 10:30:00
Worked Hrs | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  | 10:45:00 |  | 10:45:00
Sched Hrs | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  | 11:00:00 |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:15:00 |  | 11:15:00
Overtime Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 |  | 11:30:00
1st Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 11:45:00 |  | 11:45:00
2nd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 12:00:00 |  | 12:00:00
3rd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 12:15:00 |  | 12:15:00
1st Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 12:30:00 |  | 12:30:00
2nd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 12:45:00 |  | 12:45:00
3rd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 13:00:00 |  | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:15:00 |  | 13:15:00
Regular Time Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 |  | 13:30:00
1st Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 13:45:00 |  | 13:45:00
2nd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 14:00:00 |  | 14:00:00
3rd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 14:15:00 |  | 14:15:00
1st Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 14:30:00 |  | 14:30:00
2nd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 14:45:00 |  | 14:45:00
3rd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 15:00:00 |  | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:15:00 |  | 15:15:00
School & Training Time Computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 |  | 15:30:00
1st Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 15:45:00 |  | 15:45:00
2nd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 16:00:00 |  | 16:00:00
3rd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 16:15:00 |  | 16:15:00
1st Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 16:30:00 |  | 16:30:00
2nd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 16:45:00 |  | 16:45:00
3rd Shift | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  |  | 17:00:00 |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00 |  | 17:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 |  | 17:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:45:00 |  | 17:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 |  | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:15:00 |  | 18:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:30:00 |  | 18:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 |  | 18:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:15:00 |  | 19:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00 |  | 19:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:45:00 |  | 19:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 |  | 20:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:15:00 |  | 20:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00 |  | 20:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:45:00 |  | 20:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 |  | 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:15:00 |  | 21:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00 |  | 21:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:45:00 |  | 21:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:15:00 |  | 22:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:30:00 |  | 22:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:45:00 |  | 22:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  | 23:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:15:00 |  | 23:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00 |  | 23:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:45:00 |  | 23:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wellness
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FamSick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Military
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Funeral
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | School
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days Off