Spreadsheet: 39550d1237827655-if-vlookup-payroll
Sheet: Employee Time Cards

 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 198.1764705882353
 |  |  | Name | [NAME] |  |  | Emp # | 12345 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 999-99-9999 |  |  |  | Overtime | 20 |  | Sick Days Remain | 198.1764705882353
 |  |  | Date Hired | 2000-01-01 00:00:00 |  |  | Pay Category | C |  |  |  | Double Time | 25 |  | Vacation Earned | 198.1764705882353
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 24 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 32 |  | Vacation Remain | 198.1764705882353
 |  |  | 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
 |  |  | 2009-01-02 00:00:00 | Regular | 06:00:00 | 22:00:00 |  | 16 | 8 | 4 | 4
 |  |  | 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 | Sick | 06:00:00 | 22:00:00 | 1 | 8 |  |  |  | 8
 |  |  | 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 | Vacation |  |  |  |  |  |  |  |  | 8
 |  |  | 2009-01-14 00:00:00 | Vacation |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | Totals | 85 | 16 | 20 | 25 | 24 | 32
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 176.6470588235294
 |  |  | Name | [NAME] |  |  | Emp # | 22222 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 888-88-8888 |  |  |  | Overtime | 16 |  | Sick Days Remain | 176.6470588235294
 |  |  | Date Hired | 2001-01-01 00:00:00 |  |  | Pay Category | B |  |  |  | Double Time | 21 |  | Vacation Earned | 176.6470588235294
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 176.6470588235294
 |  |  | 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
 |  |  | 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 |  |  |  | Account Code | Account Code
 |  |  |  |  |  | Date |  |  | Signature
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  | Sick Days Earned | 155.1764705882353
 |  |  | Name | [NAME] |  |  | Emp # | 33333 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 777-77-7777 |  |  |  | Overtime | 16 |  | Sick Days Remain | 155.1764705882353
 |  |  | Date Hired | 2002-01-01 00:00:00 |  |  | Pay Category | A |  |  |  | Double Time | 21 |  | Vacation Earned | 155.1764705882353
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 155.1764705882353
 |  |  | 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
 |  |  | 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 | 133.7058823529412
 |  |  | Name | [NAME] |  |  | Emp # | 44444 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 666-66-6666 |  |  |  | Overtime | 16 |  | Sick Days Remain | 133.7058823529412
 |  |  | Date Hired | 2003-01-01 00:00:00 |  |  | Pay Category | C |  |  |  | Double Time | 21 |  | Vacation Earned | 133.7058823529412
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 133.7058823529412
 |  |  | 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
 |  |  | 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 | 112.2352941176471
 |  |  | Name | [NAME] |  |  | Emp # | 55555 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 555-55-5555 |  |  |  | Overtime | 16 |  | Sick Days Remain | 112.2352941176471
 |  |  | Date Hired | 2004-01-01 00:00:00 |  |  | Pay Category | B |  |  |  | Double Time | 21 |  | Vacation Earned | 112.2352941176471
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 112.2352941176471
 |  |  | 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
 |  |  | 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 | 90.70588235294117
 |  |  | Name | [NAME] 6 |  |  | Emp # | 66666 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | Manager |  |  | SSN | 444-44-4444 |  |  |  | Overtime | 16 |  | Sick Days Remain | 90.70588235294117
 |  |  | Date Hired | 2005-01-01 00:00:00 |  |  | Pay Category | A |  |  |  | Double Time | 21 |  | Vacation Earned | 90.70588235294117
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 90.70588235294117
 |  |  | 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
 |  |  | 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 | 69.23529411764706
 |  |  | Name | [NAME] 33 |  |  | Emp # | 77777 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 333-33-3333 |  |  |  | Overtime | 16 |  | Sick Days Remain | 69.23529411764706
 |  |  | Date Hired | 2006-01-01 00:00:00 |  |  | Pay Category | C |  |  |  | Double Time | 21 |  | Vacation Earned | 69.23529411764706
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 69.23529411764706
 |  |  | 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
 |  |  | 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 | 47.76470588235294
 |  |  | Name | [NAME] |  |  | Emp # | 88888 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 222-22-2222 |  |  |  | Overtime | 16 |  | Sick Days Remain | 47.76470588235294
 |  |  | Date Hired | 2007-01-01 00:00:00 |  |  | Pay Category | B |  |  |  | Double Time | 21 |  | Vacation Earned | 47.76470588235294
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 47.76470588235294
 |  |  | 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
 |  |  | 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 | 26.29411764705882
 |  |  | Name | [NAME] |  |  | Emp # | 99999 |  |  |  | Regular | 16 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 111-11-1111 |  |  |  | Overtime | 16 |  | Sick Days Remain | 26.29411764705882
 |  |  | Date Hired | 2008-01-01 00:00:00 |  |  | Pay Category | A |  |  |  | Double Time | 21 |  | Vacation Earned | 26.29411764705882
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 26.29411764705882
 |  |  | 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
 |  |  | 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