Spreadsheet: 59742d1260308817-excel-2007-hours-worked-per-unit-example
Sheet: Payroll

EMPLOYEE NAME | DATE | TYPE | TOTAL TIME
Underwriter 1
 | 2009-11-22 00:00:00 | Worked | 4.02
 | 2009-11-23 00:00:00 | Worked | 8.85
 | 2009-11-24 00:00:00 | Worked | 10.55
 | 2009-11-25 00:00:00 | Worked | 8.75
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-30 00:00:00 | Worked | 10.05
 | 2009-12-01 00:00:00 | Worked | 8.87
 | 2009-12-02 00:00:00 | Worked | 8.09
 | 2009-12-03 00:00:00 | Worked | 10.64
 | 2009-12-04 00:00:00 | Worked | 8.48
 |  | TOTAL: | 94.30000000000001
[NAME]
 | 2009-11-23 00:00:00 | Worked | 8.67
 | 2009-11-24 00:00:00 | Worked | 8.6
 | 2009-11-25 00:00:00 | Worked | 9.47
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-30 00:00:00 | Worked | 7.85
 | 2009-12-01 00:00:00 | Worked | 8.75
 | 2009-12-02 00:00:00 | Worked | 10.4
 | 2009-12-03 00:00:00 | Worked | 11.85
 | 2009-12-04 00:00:00 | Worked | 5.45
 | 2009-12-05 00:00:00 | Worked | 2.15
 |  | TOTAL: | 89.19000000000001
Underwriter 3
 | 2009-11-23 00:00:00 | Worked | 6.61
 | 2009-11-24 00:00:00 | Worked | 7.26
 | 2009-11-25 00:00:00 | Worked | 8.2
 |  | TOTAL: | 22.07
[NAME]
 | 2009-11-23 00:00:00 | Worked | 8.13
 | 2009-11-24 00:00:00 | Worked | 8.11
 | 2009-11-25 00:00:00 | Worked | 8.7
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-30 00:00:00 | Worked | 8.02
 | 2009-12-01 00:00:00 | Sick (FT) | 3.08
 | 2009-12-01 00:00:00 | Vacation (FT) | 3.85
 | 2009-12-02 00:00:00 | Worked | 8.35
 | 2009-12-03 00:00:00 | Worked | 8.15
 | 2009-12-04 00:00:00 | Worked | 8.55
 |  | TOTAL: | 80.94
Underwriter 5
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-30 00:00:00 | Worked | 7.93
 | 2009-12-01 00:00:00 | Worked | 7.62
 | 2009-12-02 00:00:00 | Worked | 8.18
 | 2009-12-03 00:00:00 | Worked | 8.27
 | 2009-12-04 00:00:00 | Worked | 6.78
 |  | TOTAL: | 54.78
Underwriter 6
 | 2009-11-30 00:00:00 | Worked | 3.98
 | 2009-12-01 00:00:00 | Worked | 0
 | 2009-12-02 00:00:00 | Worked | 7.98
 | 2009-12-03 00:00:00 | Worked | 8.49
 | 2009-12-04 00:00:00 | Worked | 3.62
 |  | TOTAL: | 24.07
Lead 1
 | 2009-11-23 00:00:00 | Worked | 7.31
 | 2009-11-24 00:00:00 | Worked | 9.29
 | 2009-11-25 00:00:00 | Worked | 8.41
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Worked | 4.97
 | 2009-11-30 00:00:00 | Worked | 9.28
 | 2009-12-01 00:00:00 | Worked | 8.75
 | 2009-12-02 00:00:00 | Worked | 10.4
 | 2009-12-03 00:00:00 | Worked | 11.92
 | 2009-12-04 00:00:00 | Worked | 9.37
 | 2009-12-05 00:00:00 | Worked | 4.65
 |  | TOTAL: | 100.35
Underwriter 7
 | 2009-11-23 00:00:00 | Worked | 9.73
 | 2009-11-24 00:00:00 | Worked | 9.27
 | 2009-11-25 00:00:00 | Worked | 9.55
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-30 00:00:00 | Worked | 10.47
 | 2009-12-01 00:00:00 | Worked | 9.08
 | 2009-12-02 00:00:00 | Worked | 8.18
 | 2009-12-03 00:00:00 | Worked | 8.42
 | 2009-12-04 00:00:00 | Worked | 9.82
 |  | TOTAL: | 90.52000000000001
Underwriter 8
 | 2009-11-23 00:00:00 | Worked | 8.07
 | 2009-11-24 00:00:00 | Worked | 8.52
 | 2009-11-25 00:00:00 | Worked | 9.35
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-30 00:00:00 | Worked | 9.08
 | 2009-12-01 00:00:00 | Worked | 8.67
 | 2009-12-02 00:00:00 | Worked | 9.55
 | 2009-12-03 00:00:00 | Worked | 9.07
 | 2009-12-04 00:00:00 | Worked | 8.8
 |  | TOTAL: | 87.11
Lead 2
 | 2009-11-22 00:00:00 | Worked | 4.97
 | 2009-11-23 00:00:00 | Worked | 10.05
 | 2009-11-24 00:00:00 | Worked | 8.48
 | 2009-11-25 00:00:00 | Worked | 8.4
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-29 00:00:00 | Worked | 2.28
 | 2009-11-30 00:00:00 | Worked | 10.97
 | 2009-12-01 00:00:00 | Worked | 9.72
 | 2009-12-02 00:00:00 | Worked | 9.82
 | 2009-12-03 00:00:00 | Worked | 9.82
 | 2009-12-04 00:00:00 | Worked | 10.67
 |  | TOTAL: | 101.18
Underwriter 9
 | 2009-11-23 00:00:00 | Sick (FT) | 8
 | 2009-11-24 00:00:00 | Worked | 8.43
 | 2009-11-25 00:00:00 | Worked | 7.75
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-30 00:00:00 | Worked | 9.22
 | 2009-12-01 00:00:00 | Worked | 8.67
 | 2009-12-02 00:00:00 | Worked | 8.97
 | 2009-12-03 00:00:00 | Worked | 8.57
 | 2009-12-04 00:00:00 | Worked | 8.5
 |  | TOTAL: | 84.11000000000001
Underwriter 10
 | 2009-11-23 00:00:00 | Worked | 8.35
 | 2009-11-24 00:00:00 | Worked | 7.65
 | 2009-11-25 00:00:00 | Worked | 8
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-30 00:00:00 | Worked | 8.37
 | 2009-12-01 00:00:00 | Worked | 7.5
 | 2009-12-02 00:00:00 | Worked | 7.73
 | 2009-12-03 00:00:00 | Worked | 7.68
 | 2009-12-04 00:00:00 | Worked | 7.82
 |  | TOTAL: | 79.1
[NAME] 11
 | 2009-11-23 00:00:00 | Worked | 9.43
 | 2009-11-24 00:00:00 | Worked | 8.81
 | 2009-11-25 00:00:00 | Worked | 7.98
 | 2009-11-26 00:00:00 | Holiday | 8
 | 2009-11-27 00:00:00 | Holiday | 8
 | 2009-11-30 00:00:00 | Worked | 9.47
 | 2009-12-01 00:00:00 | Worked | 9.27
 | 2009-12-02 00:00:00 | Worked | 8.83
 | 2009-12-03 00:00:00 | Worked | 8.63
 | 2009-12-04 00:00:00 | Worked | 8.6
 |  | TOTAL: | 87.01999999999998