Spreadsheet: 39452d1237607710-if-vlookup-payroll-3
Sheet: Employee Time Cards

 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 176.4705882352941
 |  |  | Name | [NAME] |  |  | Emp # | 12345 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 999-99-9999 |  |  |  | Overtime | 16 |  | Sick Days Remain | 176.4705882352941
 |  |  | Date Hired | 2001-01-01 00:00:00 |  |  | Pay Category | C |  |  |  | Double Time | 21 |  | Vacation Earned | 176.4705882352941
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 176.4705882352941
 |  |  | Pay Period
 |  |  |  |  |  |  |  | 11111
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00
 |  |  | 2009-01-02 00:00:00 | Regular |  |  |  |  | 8
 |  |  | 2009-01-03 00:00:00 | Weekend
 |  |  | 2009-01-04 00:00:00 | Holiday
 |  |  | 2009-01-05 00:00:00 | Sick |  |  |  |  |  |  |  | 8
 |  |  | 2009-01-06 00:00:00 | Vacation |  |  |  |  |  |  |  |  | 8
 |  |  | 2009-01-07 00:00:00 |  | 06:00:00 | 22:00:00 | 1
 |  |  | 2009-01-08 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-09 00:00:00 | Weekend | 06:00:00 | 22:00:00 | 1 | 15 |  | 12 | 3
 |  |  | 2009-01-10 00:00:00 | Holiday | 06:00:00 | 22:00:00 | 1 | 15 |  |  | 15
 |  |  | 2009-01-11 00:00:00 | Sick | 06:00:00 | 22:00:00 | 1 | 8 |  |  |  | 8
 |  |  | 2009-01-12 00:00:00 | Vacation | 06:00:00 | 22:00:00 | 1 | 8 |  |  |  |  | 8
 |  |  | 2009-01-13 00:00:00
 |  |  | 2009-01-14 00:00:00
 |  |  |  |  |  |  | Totals | 61 | 16 | 16 | 21 | 16 | 16
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 155
 |  |  | Name | [NAME] |  |  | Emp # | 22222 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 888-88-8888 |  |  |  | Overtime | 51 |  | Sick Days Remain | 155
 |  |  | Date Hired | 2002-01-01 00:00:00 |  |  | Pay Category | B |  |  |  | Double Time | 36 |  | Vacation Earned | 155
 |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  | Vacation Remain | 155
 |  |  | Pay Period
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00 | Regular | 06:00:00 | 07:00:00 | 1 | 4.996003610813204e-16 | 4.996003610813204e-16
 |  |  | 2009-01-02 00:00:00 | Regular | 06:00:00 | 18:00:00 | 1 | 11 | 8 | 3
 |  |  | 2009-01-03 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-04 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-05 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-06 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-07 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-08 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-09 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-10 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-11 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-12 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-13 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-14 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  |  |  |  |  | Totals | 191 | 104 | 51 | 36 |  |  |  |  |  | Account Code | Account Code
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 133.5294117647059
 |  |  | Name | [NAME] |  |  | Emp # | 33333 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 777-77-7777 |  |  |  | Overtime | 51 |  | Sick Days Remain | 133.5294117647059
 |  |  | Date Hired | 2003-01-01 00:00:00 |  |  | Pay Category | A |  |  |  | Double Time | 36 |  | Vacation Earned | 133.5294117647059
 |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  | Vacation Remain | 133.5294117647059
 |  |  | Pay Period
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00 | Regular | 06:00:00 | 07:00:00 | 1 | 4.996003610813204e-16 | 4.996003610813204e-16
 |  |  | 2009-01-02 00:00:00 | Regular | 06:00:00 | 18:00:00 | 1 | 11 | 8 | 3
 |  |  | 2009-01-03 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-04 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-05 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-06 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-07 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-08 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-09 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-10 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-11 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-12 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-13 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-14 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  |  |  |  |  | Totals | 191 | 104 | 51 | 36
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 112.0588235294118
 |  |  | Name | [NAME] |  |  | Emp # | 44444 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 666-66-6666 |  |  |  | Overtime | 51 |  | Sick Days Remain | 112.0588235294118
 |  |  | Date Hired | 2004-01-01 00:00:00 |  |  | Pay Category | B |  |  |  | Double Time | 36 |  | Vacation Earned | 112.0588235294118
 |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  | Vacation Remain | 112.0588235294118
 |  |  | Pay Period
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00 | Regular | 06:00:00 | 07:00:00 | 1 | 4.996003610813204e-16 | 4.996003610813204e-16
 |  |  | 2009-01-02 00:00:00 | Regular | 06:00:00 | 18:00:00 | 1 | 11 | 8 | 3
 |  |  | 2009-01-03 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-04 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-05 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-06 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-07 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-08 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-09 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-10 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-11 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-12 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-13 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-14 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  |  |  |  |  | Totals | 191 | 104 | 51 | 36
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 90.52941176470588
 |  |  | Name | [NAME] |  |  | Emp # | 55555 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 555-55-5555 |  |  |  | Overtime | 51 |  | Sick Days Remain | 90.52941176470588
 |  |  | Date Hired | 2005-01-01 00:00:00 |  |  | Pay Category | A |  |  |  | Double Time | 36 |  | Vacation Earned | 90.52941176470588
 |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  | Vacation Remain | 90.52941176470588
 |  |  | Pay Period
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00 | Regular | 06:00:00 | 07:00:00 | 1 | 4.996003610813204e-16 | 4.996003610813204e-16
 |  |  | 2009-01-02 00:00:00 | Regular | 06:00:00 | 18:00:00 | 1 | 11 | 8 | 3
 |  |  | 2009-01-03 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-04 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-05 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-06 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-07 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-08 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-09 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-10 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-11 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-12 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-13 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-14 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  |  |  |  |  | Totals | 191 | 104 | 51 | 36
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 69.05882352941177
 |  |  | Name | [NAME] 6 |  |  | Emp # | 66666 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | Manager |  |  | SSN | 444-44-4444 |  |  |  | Overtime | 51 |  | Sick Days Remain | 69.05882352941177
 |  |  | Date Hired | 2006-01-01 00:00:00 |  |  | Pay Category | C |  |  |  | Double Time | 36 |  | Vacation Earned | 69.05882352941177
 |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  | Vacation Remain | 69.05882352941177
 |  |  | Pay Period
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00 | Regular | 06:00:00 | 07:00:00 | 1 | 4.996003610813204e-16 | 4.996003610813204e-16
 |  |  | 2009-01-02 00:00:00 | Regular | 06:00:00 | 18:00:00 | 1 | 11 | 8 | 3
 |  |  | 2009-01-03 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-04 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-05 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-06 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-07 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-08 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-09 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-10 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-11 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-12 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-13 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-14 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  |  |  |  |  | Totals | 191 | 104 | 51 | 36
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 47.58823529411764
 |  |  | Name | [NAME] 33 |  |  | Emp # | 77777 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 333-33-3333 |  |  |  | Overtime | 51 |  | Sick Days Remain | 47.58823529411764
 |  |  | Date Hired | 2007-01-01 00:00:00 |  |  | Pay Category | B |  |  |  | Double Time | 36 |  | Vacation Earned | 47.58823529411764
 |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  | Vacation Remain | 47.58823529411764
 |  |  | Pay Period
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00 | Regular | 06:00:00 | 07:00:00 | 1 | 4.996003610813204e-16 | 4.996003610813204e-16
 |  |  | 2009-01-02 00:00:00 | Regular | 06:00:00 | 18:00:00 | 1 | 11 | 8 | 3
 |  |  | 2009-01-03 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-04 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-05 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-06 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-07 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-08 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-09 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-10 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-11 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-12 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-13 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-14 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  |  |  |  |  | Totals | 191 | 104 | 51 | 36
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 26.11764705882353
 |  |  | Name | [NAME] |  |  | Emp # | 88888 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 222-22-2222 |  |  |  | Overtime | 51 |  | Sick Days Remain | 26.11764705882353
 |  |  | Date Hired | 2008-01-01 00:00:00 |  |  | Pay Category | A |  |  |  | Double Time | 36 |  | Vacation Earned | 26.11764705882353
 |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  | Vacation Remain | 26.11764705882353
 |  |  | Pay Period
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00 | Regular | 06:00:00 | 07:00:00 | 1 | 4.996003610813204e-16 | 4.996003610813204e-16
 |  |  | 2009-01-02 00:00:00 | Regular | 06:00:00 | 18:00:00 | 1 | 11 | 8 | 3
 |  |  | 2009-01-03 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-04 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-05 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-06 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-07 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-08 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-09 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-10 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-11 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-12 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-13 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-14 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  |  |  |  |  | Totals | 191 | 104 | 51 | 36
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 4.588235294117647
 |  |  | Name | [NAME] |  |  | Emp # | 99999 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 111-11-1111 |  |  |  | Overtime | 51 |  | Sick Days Remain | 4.588235294117647
 |  |  | Date Hired | 2009-01-01 00:00:00 |  |  | Pay Category | C |  |  |  | Double Time | 36 |  | Vacation Earned | 4.588235294117647
 |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  | Vacation Remain | 4.588235294117647
 |  |  | Pay Period
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00 | Regular | 06:00:00 | 07:00:00 | 1 | 4.996003610813204e-16 | 4.996003610813204e-16
 |  |  | 2009-01-02 00:00:00 | Regular | 06:00:00 | 18:00:00 | 1 | 11 | 8 | 3
 |  |  | 2009-01-03 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-04 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-05 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-06 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-07 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-08 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-09 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-10 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-11 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-12 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-13 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  | 2009-01-14 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15 | 8 | 4 | 3
 |  |  |  |  |  |  | Totals | 191 | 104 | 51 | 36
 |  |  |  |  |  | Date |  |  | Signature