Spreadsheet: 91368d1291125353-vlookup-and-get-rid-of-n-a-error-test2
Sheet: Sheet1

 |  |  | Paste Full time hours here
 | WEEKLY HOURS FOR PAYROLL INPUT |  |  |  |  |  |  | Bank holiday set
 | WEEK ENDING 21 November 2010 |  |  |  |  |  |  | Mon-Thurs |  | Fri
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  | F/T Hourly Rate
 | 0 |  |  |  |  | OT | OT | OT | TOTAL | HOLIDAYS | HOLIDAYS |  |  | 9 |  |  | Breakdown of Hours by Department
 | NO. | NAME | NO | GROUP | NORMAL | @ | @ | @ |  | HOURS | HOURS |  |  |  |  |  | [NAME] | Recycling Hrs | Fabrication Hrs
 |  |  |  |  | BASIC | TIME+1/3 | TIME+1/2 | 2 TIME | HOURS | PUBLIC | ANNUAL |  |  | Total F/T Hours | Value (£'s) |  | MFGW | MFGR | MFGF
 | W003 | names removed for data protection | 1 | MFGW | 40 | 2.5 |  |  | 42.5 |  |  |  |  | 85 | 765 |  | 85 | #N/A | #N/A
 | W023a |  | 1 | MFGW | 40 | 8 | 6.25 |  | 54.25 |  |  |  |  | 108.5 | 976.5 |  | 108.5 | #N/A | #N/A
 | W086 |  | 1 | MFG |  |  |  |  | 0 |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 | W101 |  | 1 | MFGW | 24.75 | 5.25 |  |  | 30 |  | 15.25 |  |  | 75.25 | 677.25 |  | 75.25 | #N/A | #N/A
 | W127 |  | 1 | MFGW | 40 | 8 | 0.75 |  | 48.75 |  |  |  |  | 97.5 | 877.5 |  | 97.5 | #N/A | #N/A
 | W131 |  | 1 | MFGW |  | 51.75 | 5.5 |  | 57.25 |  |  |  |  | 114.5 | 1030.5 |  | 114.5 | #N/A | #N/A
 | W143 |  | 1 | MFGR | 28.5 |  |  |  | 28.5 |  |  |  |  | 57 | 513 |  | #N/A | 57 | #N/A
 | W174 |  | 1 | MFGW |  | 52 | 5.5 |  | 57.5 |  |  |  |  | 115 | 1035 |  | 115 | #N/A | #N/A
 | W175 |  | 1 | MFGW | 40 | 6.5 |  |  | 46.5 |  |  |  |  | 93 | 837 |  | 93 | #N/A | #N/A
 | W176 |  | 1 | MFGW | 39.5 |  |  |  | 39.5 |  |  |  |  | 79 | 711 |  | 79 | #N/A | #N/A
 | W178 |  | 1 | MFGF | 40 | 8 | 12.75 |  | 60.75 |  |  |  |  | 121.5 | 1093.5 |  | #N/A | #N/A | 121.5
 | W179 |  | 1 | MFGW | 40 | 0.75 |  |  | 40.75 |  |  |  |  | 81.5 | 733.5 |  | 81.5 | #N/A | #N/A
 | W183A |  | 1 | MFGW | 31.75 | 8 | 0.75 |  | 40.5 |  | 8.25 |  |  | 89.25 | 803.25 |  | 89.25 | #N/A | #N/A
 | W184 |  | 1 | MFGW | 40 | 0.5 |  |  | 40.5 |  |  |  |  | 81 | 729 |  | 81 | #N/A | #N/A
 | W186 |  | 1 | MFGW | 40 | 4.75 |  |  | 44.75 |  |  |  |  | 89.5 | 805.5 |  | 89.5 | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | Totals | 1287.5 | 11587.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | P/T Hourly Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.02
 |  |  | Paste Temp hours here
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total P/T Hours | Value (£'s)
 |  |  | 1 | MFGW |  |  |  |  | 139 |  |  |  |  | 139 | 1114.78
 |  |  | 1 | MFGW |  |  |  |  | 39 |  |  |  |  | 39 | 312.78
 |  |  | 1 | MFGW |  |  |  |  | 63 |  |  |  |  | 63 | 505.26
 |  |  | 1 | MFGW |  |  |  |  | 40 |  |  |  |  | 40 | 320.8
 |  |  | 1 | MFGF |  |  |  |  | 84 |  |  |  |  | 84 | 673.68
 |  |  | 1 | MFGR |  |  |  |  | 175 |  |  |  |  | 175 | 1403.5
 |  |  | 1 | MFGW |  |  |  |  | 56 |  |  |  |  | 56 | 449.12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Totals | 596 | 4779.919999999999