Spreadsheet: 145543d1331645831-time-card-workbook-pivot-tables-best-way-copy-of-2012-hour-log
Sheet: January

Bi Weekly Hour Log
 |  |  |  | Week 1 |  |  |  |  |  |  |  | Week 2
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Total Week 1 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Total Week 2 | Total Hours For Pay Periord |  | Pay Rate |  | Total Cost for Pay Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Employee
Francisco |  |  | 7 | 5 | 6 | 4 | 3 |  |  | 4.5 | 6 | 3 | 6 | 3 |  |  |  |  | Francisco | 11.5
Martin |  |  |  | 40 VAC |  |  |  |  |  | 4.5 | 6 | 3 | 6 | 3 |  |  |  |  | Martin | 10.5
[NAME] |  | 6.25 | 3.5 | 4 | 5.75 | 4 | 3.5 | 3 |  | 3.25 | 6 |  | 6 | 5.5 |  |  |  |  | [NAME] | 9.75
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9.75
[NAME] |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9.75
[NAME] |  | 3 |  |  | 7.25 | 4 | 3 | 3 |  | 4.5 | 5.5 |  | 6 | 3 |  |  |  |  | [NAME] | 8.5
[NAME] |  | 3.5 | 4.25 | 4.25 | 5 | 4.75 |  |  |  | 5.75 | 6.5 | 5 | 6.25 | 3.75 |  |  |  |  | [NAME] | 8.5
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 13
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10.5
Manuel P |  | 6 | 5 | 5 | 6 | 4 | 4 |  |  | 5 | 6.5 | 3 | 6.75 | 3 |  |  |  |  | Manuel P | 10
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 13
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9.5
[NAME] |  | 6 | 5 | 5 | 6 | 4 | 4 |  |  | 5 | 6.5 | 3 | 6.5 | 3 |  |  |  |  | [NAME] | 8.5
Natividad |  | 6 | 5 | 5 | 6 | 4 | 4 |  |  | 5 | 6.5 | 3 | 6.5 | 3 |  |  |  |  | Natividad | 8.5
Shadrik |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shadrik | 8.5
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dale |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Payroll Cost for Pay Peroiod
Bi Weekly Hour Log
 |  |  |  | Week 1 |  |  |  |  |  |  |  | Week 2
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Total Week 1 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Total Week 2 | Total Hours For Pay Periord |  | Pay Rate |  | Total Cost for Pay Period
 |  | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 |  | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 |  |  |  |  |  | Per Employee
Francisco |  | 6 | 5.5 | 6 | 4 | 4 |  |  |  | 3 | 6 | 6 | 5 | 3.75 | 3 | 3 |  |  | Francisco | 11.5
Martin |  | 6 | 5.5 | 6 | 4 | 4 |  |  |  | 3 | 6 | 6 | 5 | 3.75 | 3 |  |  |  | Martin | 10.5
[NAME] |  | 6 | 5.5 | 6 | 4.25 | 4 |  |  |  |  |  |  |  | 4 |  |  |  |  | [NAME] | 9.75
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9.75
[NAME] |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 |  |  | [NAME] | 9.75
[NAME] |  |  | 8 | 6 | 8 | 3 |  |  |  | 4.5 | 5.75 | 7.25 | 5.75 |  |  |  |  |  | [NAME] | 8.5
[NAME] |  | 2.5 | 5.25 | 4.25 | 5 | 4.5 |  |  |  | 3.5 | 5.5 | 5 | 5 | 4.75 |  |  |  |  | [NAME] | 8.5
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 13
[NAME] |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 |  |  | [NAME] | 10.5
Manuel P |  | 6 | 5.5 | 6 | 4 | 4 | 3 |  |  | 3 | 6 | 6 | 5 | 3.75 |  |  |  |  | Manuel P | 10
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 13
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9.5
[NAME] |  | 6 | 5.5 | 6 | 4 | 4 |  |  |  |  |  |  | 5.5 | 3.75 | 3 |  |  |  | [NAME] | 8.5
Natividad |  | 6 | 5.5 | 6 | 4 | 4 |  |  |  | 3 | 6 | 6 | 5 | 3.75 |  |  |  |  | Natividad | 8.5
Shadrik |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shadrik | 8.5
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dale |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Payroll Cost for Pay Peroiod