Spreadsheet: 94303d1294157468-adding-employees-hours-from-different-cells-democlassificationreport
Sheet: Sheet2

Demo Class | Store # | Demo Date | [NAME] | Employee Name | ADP Number | Employee Type | Hours Worked
Roadshow (Food) | 403 | 2010-12-22 00:00:00 | General Mills | [NAME] | 30632 | Sales Advisor | 2
Roadshow (Food) | 369 | 2010-12-22 00:00:00 | [NAME] | [NAME] | 38788 | Shift Supervisor | 1
Roadshow (Food) | 116 | 2010-12-22 00:00:00 | Tyson Foods | [NAME] | 38788 | Shift Supervisor | 7
Roadshow (Food) | 369 | 2010-12-22 00:00:00 | Starbucks | [NAME] | 38788 | Shift Supervisor | 9
Roadshow (Food) | 369 | 2010-12-22 00:00:00 | General Mills | [NAME] | 38788 | Shift Supervisor | 2
Roadshow (Food) | 311 | 2010-12-22 00:00:00 | Pasta Foods | [NAME] | 38788 | Shift Supervisor | 5
Roadshow (Food) | 403 | 2010-12-22 00:00:00 | [NAME] | [NAME] | 30632 | Sales Advisor | 6
Roadshow (Food) | 311 | 2010-12-22 00:00:00 | Sun Dried Tomatoes | [NAME] | 38788 | Shift Supervisor | 5.5
Roadshow (Food) | 369 | 2010-12-22 00:00:00 | [NAME] | [NAME] | 54127 | Sales Advisor | 12
Roadshow (Food) | 403 | 2010-12-22 00:00:00 | Dare Crackers | [NAME] | 30632 | Sales Advisor | 4.25
Roadshow (Food) | 116 | 2010-12-22 00:00:00 | Irish Creamer | [NAME] | 38788 | Shift Supervisor | 4.75
Roadshow (Food) | 88 | 2010-12-22 00:00:00 | Tyson Foods | [NAME] | 30632 | Sales Advisor | 10
Roadshow (Food) | 370 | 2010-12-22 00:00:00 | [NAME] | [NAME] | 25587 | Sales Advisor | 13
Below is what I want the layout should look like
Store # | Demo Date | Employee Name | ADP Number | Employee Type | Hours Worked | [NAME] | Demo Class
403 | 2010-12-22 00:00:00 | [NAME] | 30632 | Sales Advisor | 12.25 | General Mills | Roadshow (Food)
BTW, below is the actual format (or raw data) when I import them from our system.
Demo Class | Div. | Store # | Demo Date | Dept. | [NAME] | Item # | Item Description | Area Manager | Employee Name | ADP Number | Employee Type | Hours Worked | Total Paid | Demo Count | Labor Charge | Labor Charge Tax | Product Charge | Product Charge Tax | Supply Charge | Enhancements | Total Billed
 | MW | 368 | 2010-12-22 00:00:00 | 12 | Garden Fresh Salsa | 159376 | Gourmet Blue Corn Tortilla Chips | [NAME] | [NAME] | 35552 | Sales Advisor | 6 | 66 | 0.5 | 75 | 0 | 21.95 | 0.93 | 3.75 | 0 | 101.63
 | MW | 370 | 2010-12-22 00:00:00 | 12 | Garden Fresh Salsa | 159376 | Gourmet Blue Corn Tortilla Chips | [NAME] | [NAME] | 13098 | Shift Supervisor | 6 | 72 | 0.5 | 75 | 0 | 17.56 | 0 | 3.75 | 0 | 96.31
 | MW | 1007 | 2010-12-22 00:00:00 | 12 | Garden Fresh Salsa | 159376 | Gourmet Blue Corn Tortilla Chips | [NAME] | Maryann  Campbell | 49460 | Sales Advisor | 6 | 66 | 0.5 | 75 | 0 | 17.56 | 0 | 3.75 | 0 | 96.31
 | MW | 371 | 2010-12-22 00:00:00 | 12 | Garden Fresh Salsa | 159376 | Gourmet Blue Corn Tortilla Chips | [NAME] | [NAME] | 24931 | Sales Advisor | 6 | 66 | 0.5 | 75 | 0 | 26.34 | 0.46 | 3.75 | 0 | 105.55
 | MW | 372 | 2010-12-22 00:00:00 | 12 | Garden Fresh Salsa | 159376 | Gourmet Blue Corn Tortilla Chips | [NAME] | Helmut  Rischer | 48960 | Sales Advisor | 6 | 66 | 1 | 150 | 0 | 26.34 | 0 | 7.5 | 24.95 | 208.79
Thanks in advance.
Sum of Hours Worked |  |  |  |  |  |  |  |  | Sum of Hours Worked
Store # | Demo Date | Employee Name | ADP Number | [NAME] | Demo Class | Total |  |  | Store # | Demo Date | Employee Name | ADP Number | Demo Class | Total
88 | 2010-12-22 00:00:00 | [NAME] | 30632 | Tyson Foods | Roadshow (Food) | 10 |  |  | 88 | 2010-12-22 00:00:00 | [NAME] | 30632 | Roadshow (Food) | 10
 |  | [NAME] |  |  |  | 10 |  |  | 116 | 2010-12-22 00:00:00 | [NAME] | 38788 | Roadshow (Food) | 11.75
116 | 2010-12-22 00:00:00 | [NAME] | 38788 | Irish Creamer | Roadshow (Food) | 4.75 |  |  | 311 | 2010-12-22 00:00:00 | [NAME] | 38788 | Roadshow (Food) | 10.5
 |  |  |  | Tyson Foods | Roadshow (Food) | 7 |  |  | 369 | 2010-12-22 00:00:00 | [NAME] | 54127 | Roadshow (Food) | 12
 |  | [NAME] |  |  |  | 11.75 |  |  |  |  | [NAME] | 38788 | Roadshow (Food) | 12
311 | 2010-12-22 00:00:00 | [NAME] | 38788 | Pasta Foods | Roadshow (Food) | 5 |  |  | 370 | 2010-12-22 00:00:00 | [NAME] | 25587 | Roadshow (Food) | 13
 |  |  |  | Sun Dried Tomatoes | Roadshow (Food) | 5.5 |  |  | 403 | 2010-12-22 00:00:00 | [NAME] | 30632 | Roadshow (Food) | 12.25
 |  | [NAME] |  |  |  | 10.5
369 | 2010-12-22 00:00:00 | [NAME] | 54127 | [NAME] | Roadshow (Food) | 12
 |  | [NAME] |  |  |  | 12
 |  | [NAME] | 38788 | General Mills | Roadshow (Food) | 2
 |  |  |  | [NAME] | Roadshow (Food) | 1
 |  |  |  | Starbucks | Roadshow (Food) | 9
 |  | [NAME] Total |  |  |  | 12
370 | 2010-12-22 00:00:00 | [NAME] | 25587 | [NAME] | Roadshow (Food) | 13
 |  | [NAME] |  |  |  | 13
403 | 2010-12-22 00:00:00 | [NAME] | 30632 | Dare Crackers | Roadshow (Food) | 4.25
 |  |  |  | General Mills | Roadshow (Food) | 2
 |  |  |  | [NAME] | Roadshow (Food) | 6
 |  | [NAME] |  |  |  | 12.25