Spreadsheet: 39218d1237404934-if-vlookup-payroll
Sheet: Employee Time Cards

 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours | #N/A |  | Sick Days Earned | 176.3529411764706 |  |  |  | Position |  | Category
 |  |  | Name | [NAME] |  |  | Emp # | 11111 |  |  |  | Regular | #N/A |  | Sick Days Used |  |  |  |  | General |  | A
 |  |  | Position | General |  |  | SSN | 555-55-5555 |  |  |  | Overtime | #N/A |  | Sick Days Remain | 176.3529411764706 |  |  |  | Tech |  | B
 |  |  | Date Hired | 2001-01-01 00:00:00 |  |  | Pay Category | C |  |  |  | Double Time | #N/A |  | Vacation Earned | 176.3529411764706 |  |  |  | A Manager |  | C
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 16 |  | Vacation Used |  |  |  |  | Manager |  | D
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  | Vacation Remain | 176.3529411764706
 |  |  | 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 |  |  |  |  | #N/A |  | #N/A | #N/A
 |  |  | 2009-01-02 00:00:00 | Regular |  |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | 2009-01-03 00:00:00 | Weekend |  |  |  | #N/A |  | #N/A | #N/A
 |  |  | 2009-01-04 00:00:00 | Holiday |  |  |  | #N/A |  | #N/A | #N/A
 |  |  | 2009-01-05 00:00:00 | Sick |  |  |  | 8 |  |  |  | 8
 |  |  | 2009-01-06 00:00:00 | Vacation |  |  |  | 8 |  |  |  |  | 8
 |  |  | 2009-01-07 00:00:00 |  | 06:00:00 | 22:00:00 | 1 | #N/A |  | #N/A | #N/A
 |  |  | 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 |  |  |  |  | #N/A |  | #N/A | #N/A
 |  |  | 2009-01-14 00:00:00 |  |  |  |  | #N/A |  | #N/A | #N/A
 |  |  |  |  |  |  | Totals | #N/A | #N/A | #N/A | #N/A | 16 | 16
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours | 191 |  | Sick Days Earned | 154.8823529411765
 |  |  | Name | [NAME] |  |  | Emp # | 22222 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 555-55-5555 |  |  |  | Overtime | 51 |  | Sick Days Remain | 154.8823529411765
 |  |  | Date Hired | 2002-01-01 00:00:00 |  |  | Pay Category | B |  |  |  | Double Time | 36 |  | Vacation Earned | 154.8823529411765
 |  |  |  |  |  |  |  |  |  |  |  | Sick | #N/A |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | #N/A |  | Vacation Remain | 154.8823529411765
 |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <>
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours | 191 |  | Sick Days Earned | 133.4117647058823
 |  |  | Name | [NAME] |  |  | Emp # | 33333 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | General |  |  | SSN | 555-55-5555 |  |  |  | Overtime | 51 |  | Sick Days Remain | 133.4117647058823
 |  |  | Date Hired | 2003-01-01 00:00:00 |  |  | Pay Category | A |  |  |  | Double Time | 36 |  | Vacation Earned | 133.4117647058823
 |  |  |  |  |  |  |  |  |  |  |  | Sick | #N/A |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | #N/A |  | Vacation Remain | 133.4117647058823
 |  |  | 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
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours | 191 |  | Sick Days Earned | 111.9411764705882
 |  |  | Name | [NAME] |  |  | Emp # | 44444 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 555-55-5555 |  |  |  | Overtime | 51 |  | Sick Days Remain | 111.9411764705882
 |  |  | Date Hired | 2004-01-01 00:00:00 |  |  | Pay Category | C |  |  |  | Double Time | 36 |  | Vacation Earned | 111.9411764705882
 |  |  |  |  |  |  |  |  |  |  |  | Sick | #N/A |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | #N/A |  | Vacation Remain | 111.9411764705882
 |  |  | 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
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours | 191 |  | Sick Days Earned | 90.41176470588235
 |  |  | Name | [NAME] |  |  | Emp # | 55555 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | Tech |  |  | SSN | 555-55-5555 |  |  |  | Overtime | 51 |  | Sick Days Remain | 90.41176470588235
 |  |  | Date Hired | 2005-01-01 00:00:00 |  |  | Pay Category | A |  |  |  | Double Time | 36 |  | Vacation Earned | 90.41176470588235
 |  |  |  |  |  |  |  |  |  |  |  | Sick | #N/A |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | #N/A |  | Vacation Remain | 90.41176470588235
 |  |  | 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
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours | 191 |  | Sick Days Earned | 68.94117647058823
 |  |  | Name | [NAME] 6 |  |  | Emp # | 66666 |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position | Manager |  |  | SSN | 555-55-5555 |  |  |  | Overtime | 51 |  | Sick Days Remain | 68.94117647058823
 |  |  | Date Hired | 2006-01-01 00:00:00 |  |  | Pay Category | B |  |  |  | Double Time | 36 |  | Vacation Earned | 68.94117647058823
 |  |  |  |  |  |  |  |  |  |  |  | Sick | #N/A |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | #N/A |  | Vacation Remain | 68.94117647058823
 |  |  | 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
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours | 191 |  | Sick Days Earned | 47.47058823529412
 |  |  | Name |  |  |  | Emp # |  |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position |  |  |  | SSN |  |  |  |  | Overtime | 51 |  | Sick Days Remain | 47.47058823529412
 |  |  | Date Hired | 2007-01-01 00:00:00 |  |  | Pay Category |  |  |  |  | Double Time | 36 |  | Vacation Earned | 47.47058823529412
 |  |  |  |  |  |  |  |  |  |  |  | Sick | #N/A |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | #N/A |  | Vacation Remain | 47.47058823529412
 |  |  | 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
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours | 191 |  | Sick Days Earned | 26
 |  |  | Name |  |  |  | Emp # |  |  |  |  | Regular | 104 |  | Sick Days Used
 |  |  | Position |  |  |  | SSN |  |  |  |  | Overtime | 51 |  | Sick Days Remain | 26
 |  |  | Date Hired | 2008-01-01 00:00:00 |  |  | Pay Category |  |  |  |  | Double Time | 36 |  | Vacation Earned | 26
 |  |  |  |  |  |  |  |  |  |  |  | Sick | #N/A |  | Vacation Used
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | #N/A |  | Vacation Remain | 26
 |  |  | 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