Spreadsheet: 94985d1294712622-adding-employees-hours-from-different-cells-democlassificationreport-small-1-
Sheet: Sheet4

Sum of Hours Worked
Store # | Demo Date | Employee Name | ADP Number | Demo Class | Total
116 | 2010-12-27 00:00:00 | [NAME] | 53173 | Merchandising Project | 2
204 | 2010-12-22 00:00:00 | [NAME] | 46783 | Roadshow (Food) | 11
206 | 2010-12-22 00:00:00 | Evangelina Crane | 42535 | Roadshow (Food) | 6.5
 |  | [NAME] | 49340 | Roadshow (Food) | 5.5
 |  | [NAME] | 53790 | Roadshow (Food) | 5.5
 | 2010-12-23 00:00:00 | [NAME] | 50076 | Roadshow (Food) | 5.5
 |  | Heather Dempsey | 48376 | Roadshow (Food) | 11.5
 |  | [NAME] | 53883 | Roadshow (Food) | 5.5
 |  | [NAME] | 53790 | Roadshow (Food) | 5.5
 | 2010-12-24 00:00:00 | Heather Dempsey | 48376 | Roadshow (Food) | 7
213 | 2010-12-24 00:00:00 | [NAME] | 36766 | Not Applicable | 10
214 | 2010-12-24 00:00:00 | Alis Parada | 34736 | Not Applicable | 8.5
 |  | Juana Quispe-Poma | 30235 | Not Applicable | 8.5
218 | 2010-12-23 00:00:00 | Diego  Mejias | 49366 | Roadshow (Food) | 12.25
 |  | [NAME] | 53920 | Roadshow (Food) | 11.75
 |  | [NAME] | 47941 | Roadshow (Food) | 11.75
221 | 2010-12-22 00:00:00 | Keila  Carbonell | 54273 | Roadshow (Food) | 5.25
 |  | [NAME] | 20356 | Roadshow (Food) | 6.25
 |  | [NAME] | 47013 | Roadshow (Food) | 6.25
 |  | Nevada Hall | 53429 | Roadshow (Food) | 5.5
 |  | [NAME] | 29759 | Roadshow (Food) | 11.25
 | 2010-12-23 00:00:00 | Alexander  Hynes | 54038 | Roadshow (Food) | 11.25
 |  | [NAME] | 49919 | Roadshow (Food) | 6.25
 |  | Keila  Carbonell | 54273 | Roadshow (Food) | 5.25
 |  | [NAME] | 52411 | Roadshow (Food) | 11.75
226 | 2010-12-22 00:00:00 | [NAME] | 54709 | Roadshow (Food) | 4
 |  | [NAME] Rival | 50872 | Roadshow (Food) | 12.5
 |  | [NAME] | 48643 | Roadshow (Food) | 6.75
 |  | [NAME] | 48595 | Roadshow (Food) | 12.5
 | 2010-12-23 00:00:00 | Nayshri Singh | 47761 | Roadshow (Food) | 12.5
 |  | [NAME] | 48595 | Roadshow (Food) | 12.5
227 | 2010-12-22 00:00:00 | [NAME] | 43008 | Roadshow (Food) | 12
 | 2010-12-23 00:00:00 | [NAME] | 54634 | Roadshow (Food) | 11
 |  | [NAME] | 52706 | Roadshow (Food) | 11
231 | 2010-12-22 00:00:00 | [NAME]  Vargas | 50954 | Roadshow (Food) | 12
 |  | [NAME] | 51551 | Roadshow (Food) | 12
 | 2010-12-23 00:00:00 | Patrocinia Pinto | 32554 | Roadshow (Food) | 12
233 | 2010-12-23 00:00:00 | [NAME] | 33559 | Not Applicable | 7.5
 |  | [NAME] | 41771 | Not Applicable | 10.5
 |  | [NAME] | 37306 | Not Applicable | 10.5
 |  | [NAME] | 45452 | Not Applicable | 3
 |  | [NAME] | 52502 | Not Applicable | 10.5
237 | 2010-12-23 00:00:00 | [NAME] | 50757 | Roadshow (Food) | 11.5
 |  | [NAME] | 53463 | Roadshow (Food) | 2.5
239 | 2010-12-23 00:00:00 | [NAME] | 43175 | Not Applicable | 10
241 | 2010-12-23 00:00:00 | [NAME] | 50008 | Roadshow (Food) | 4.5
243 | 2010-12-22 00:00:00 | Camilo  Cortes | 51223 | Roadshow (Food) | 12
 |  | [NAME] | 46463 | Roadshow (Food) | 12
 |  | [NAME] | 54177 | Not Applicable | 10
 | 2010-12-23 00:00:00 | [NAME] | 46463 | Not Applicable | 10
244 | 2010-12-22 00:00:00 | [NAME] | 47103 | Roadshow (Food) | 11.5
246 | 2010-12-22 00:00:00 | [NAME] | 32204 | Roadshow (Food) | 5.5
 | 2010-12-23 00:00:00 | [NAME] | 41081 | Roadshow (Food) | 5.5
 |  | [NAME] | 32715 | Roadshow (Food) | 5.5
 |  | [NAME] | 32204 | Roadshow (Food) | 5
 | 2010-12-24 00:00:00 | [NAME] | 41081 | Roadshow (Food) | 7.75
 |  | [NAME] | 32715 | Roadshow (Food) | 8.25
 |  | [NAME] | 32204 | Roadshow (Food) | 7.75
 |  | [NAME] | 47753 | Roadshow (Food) | 7.75
248 | 2010-12-23 00:00:00 | Mina  Tailor | 48650 | Roadshow (Food) | 5
249 | 2010-12-23 00:00:00 | Celeste Poole | 34168 | Roadshow (Food) | 7.5
306 | 2010-12-22 00:00:00 | Carmen Rosario | 9210 | Roadshow (Food) | 4.5
 |  | [NAME] | 37346 | Roadshow (Food) | 7
 | 2010-12-23 00:00:00 | Carmen Rosario | 9210 | Roadshow (Food) | 4.5
310 | 2010-12-23 00:00:00 | [NAME] | 51601 | Roadshow (Food) | 11.5
 |  | Junior  Vassell | 54674 | Roadshow (Food) | 11.5
315 | 2010-12-22 00:00:00 | [NAME] | 19787 | Roadshow (Food) | 11.25
 |  | [NAME] | 47113 | Roadshow (Food) | 11.25
 | 2010-12-23 00:00:00 | [NAME] | 32342 | Roadshow (Food) | 11.25
317 | 2010-12-27 00:00:00 | [NAME] | 39240 | Roadshow (Food) | 4.5
321 | 2010-12-23 00:00:00 | Gino Amicucci | 39888 | Roadshow (Food) | 5.5
 |  | [NAME] | 54278 | Roadshow (Food) | 5.25
 |  | [NAME] | 28508 | Roadshow (Food) | 5
 | 2010-12-24 00:00:00 | [NAME] | 30180 | Roadshow (Food) | 7
322 | 2010-12-23 00:00:00 | [NAME] | 50532 | Roadshow (Food) | 11
330 | 2010-12-23 00:00:00 | [NAME] | 54792 | Not Applicable | 8.5
340 | 2010-12-22 00:00:00 | [NAME] | 21701 | Not Applicable | 7.5
344 | 2010-12-28 00:00:00 | [NAME]  Ehrhardt | 49737 | Not Applicable | 10
346 | 2010-12-28 00:00:00 | [NAME] | 25957 | Not Applicable
348 | 2010-12-28 00:00:00 | Margot Mills | 46946 | Not Applicable | 9.5
349 | 2010-12-28 00:00:00 | [NAME] | 49718 | Not Applicable | 10.5
363 | 2010-12-22 00:00:00 |  | 0 | Merchandising Project | 0
368 | 2010-12-22 00:00:00 | [NAME] | 35552 | (blank) | 6
 | 2010-12-28 00:00:00 | [NAME] | 52843 | Not Applicable | 6
369 | 2010-12-28 00:00:00 | [NAME] | 46932 | Not Applicable | 9.25
 |  | [NAME] | 54630 | (blank) | 6
374 | 2010-12-26 00:00:00 | [NAME] | 18333 | General Merchandise Demonstration | 6.75
375 | 2010-12-23 00:00:00 | [NAME] | 54127 | (blank) | 6
376 | 2010-12-28 00:00:00 | Donetta Finkbeiner | 16524 | Not Applicable | 8.75
377 | 2010-12-22 00:00:00 | [NAME] | 41657 | General Merchandise Demonstration | 4.75
378 | 2010-12-28 00:00:00 | [NAME] | 49715 | Not Applicable | 9
379 | 2010-12-28 00:00:00 | [NAME] | 43308 | Not Applicable | 9.5
380 | 2010-12-26 00:00:00 | [NAME] | 29707 | General Merchandise Demonstration | 6.75
 | 2010-12-28 00:00:00 | [NAME] | 50808 | Not Applicable | 10
384 | 2010-12-28 00:00:00 | [NAME] | 9546 | Not Applicable | 6
 |  | Heather  Brockner | 42991 | Not Applicable | 3
387 | 2010-12-23 00:00:00 | [NAME]  Cismesia | 52063 | Not Applicable | 4.25
 | 2010-12-28 00:00:00 | [NAME] | 41197 | Not Applicable | 8.25
388 | 2010-12-26 00:00:00 | [NAME] | 8317 | General Merchandise Demonstration | 6.75
439 | 2010-12-22 00:00:00 | [NAME] | 43232 | Roadshow (Food) | 5.5
 |  | [NAME] | 32647 | Roadshow (Food) | 5.5
 |  | [NAME] | 48087 | Roadshow (Food) | 5.5
 |  | Teresa  Samilton | 39968 | Roadshow (Food) | 5.5
440 | 2010-12-27 00:00:00 | [NAME] | 27955 | Merchandising Project | 0.25
443 | 2010-12-27 00:00:00 | Janice  King | 48737 | Merchandising Project | 2
480 | 2010-12-24 00:00:00 | [NAME] | 48625 | Merchandising Project | 2
625 | 2010-12-28 00:00:00 | [NAME] | 49674 | Not Applicable | 11
626 | 2010-12-22 00:00:00 | Odilka Del Rosario | 37196 | Not Applicable | 8.5
628 | 2010-12-28 00:00:00 | [NAME] | 50407 | Not Applicable | 9.5
629 | 2010-12-27 00:00:00 | [NAME] | 21665 | Merchandising Project | 0.25
631 | 2010-12-23 00:00:00 | [NAME] | 52733 | Roadshow (Food) | 10.25
 |  | [NAME] | 34440 | Roadshow (Food) | 10.25
632 | 2010-12-28 00:00:00 | [NAME]  Fichter | 53339 | Not Applicable | 9.5
634 | 2010-12-28 00:00:00 | [NAME] | 46676 | Not Applicable | 8.25
637 | 2010-12-27 00:00:00 |  | 0 | Merchandising Project | 0
645 | 2010-12-23 00:00:00 | [NAME] | 52752 | Roadshow (Food) | 9
 |  | [NAME] | 51610 | Roadshow (Food) | 9
647 | 2010-12-28 00:00:00 | Christina  Burtner | 51380 | Not Applicable | 9.5
649 | 2010-12-23 00:00:00 | [NAME] | 48172 | Roadshow (Food) | 6.75
664 | 2010-12-27 00:00:00 | [NAME] | 43489 | Not Applicable | 10.75
 |  | [NAME] | 50266 | Not Applicable | 10.75
 | 2010-12-28 00:00:00 | [NAME] | 43489 | Not Applicable | 10.75
 |  | [NAME] | 51533 | Not Applicable | 10.75
669 | 2010-12-28 00:00:00 | [NAME] | 50420 | Not Applicable | 9
673 | 2010-12-24 00:00:00 | [NAME] | 47437 | (blank) | 6
676 | 2010-12-27 00:00:00 | Cindy  Laurent | 50884 | Merchandising Project | 2.5
 |  | [NAME] | 24383 | Merchandising Project | 0.5
681 | 2010-12-23 00:00:00 | [NAME] | 48725 | Roadshow (Food) | 6.5
684 | 2010-12-28 00:00:00 | Jacqualine Trice | 46065 | Not Applicable | 11
689 | 2010-12-28 00:00:00 | [NAME] | 51899 | Not Applicable | 5
 |  | [NAME] | 43960 | Not Applicable | 5.5
693 | 2010-12-28 00:00:00 | [NAME] | 23544 | Not Applicable | 11
739 | 2010-12-22 00:00:00 | [NAME] | 53567 | Roadshow (Food) | 5.5
743 | 2010-12-23 00:00:00 | Temporary Employee | 99971 | General Merchandise Demonstration
768 | 2010-12-28 00:00:00 | [NAME] | 39084 | Not Applicable | 5.75
 |  | [NAME] | 39081 | Not Applicable | 5.5
774 | 2010-12-28 00:00:00 | [NAME] | 45649 | Not Applicable | 5
 |  | [NAME] | 41987 | Not Applicable | 5.5
784 | 2010-12-28 00:00:00 | [NAME] | 41225 | Not Applicable | 4.5
 |  | [NAME] | 42150 | Not Applicable | 5
1005 | 2010-12-23 00:00:00 | Rosario Almeida | 20166 | Roadshow (Food) | 8.75
1006 | 2010-12-28 00:00:00 | [NAME] | 40000 | Not Applicable | 5
 |  | [NAME] | 44966 | Not Applicable | 6.5
 |  | [NAME] | 47897 | Not Applicable | 4.5
1012 | 2010-12-23 00:00:00 | [NAME] | 42261 | Not Applicable | 5
1014 | 2010-12-27 00:00:00 | [NAME] | 48099 | Merchandising Project | 1.5
1016 | 2010-12-27 00:00:00 | [NAME] | 39964 | Merchandising Project | 3
 |  | [NAME] | 41690 | Merchandising Project | 1
1020 | 2010-12-28 00:00:00 | [NAME] | 44058 | Not Applicable | 8
1022 | 2010-12-27 00:00:00 | Marion  Smith | 53241 | Merchandising Project | 1.25
1027 | 2010-12-27 00:00:00 | [NAME] | 43789 | Merchandising Project | 2
1030 | 2010-12-27 00:00:00 | Jeana  McLellan | 49211 | Merchandising Project | 1.5
1037 | 2010-12-28 00:00:00 | [NAME] | 45944 | Not Applicable | 6.5
 |  | [NAME] | 32588 | Not Applicable | 4.75
1062 | 2010-12-24 00:00:00 | [NAME] | 52461 | Not Applicable | 7.5
 |  | [NAME] | 49487 | Not Applicable | 7.5
1070 | 2010-12-23 00:00:00 | [NAME] | 54606 | Roadshow (Food) | 12
1074 | 2010-12-28 00:00:00 | Megan Crownover | 54346 | Not Applicable | 10
1088 | 2010-12-22 00:00:00 | Julia  Buchanan | 54210 | (blank) | 6
 | 2010-12-28 00:00:00 | Maureen Chytil | 54105 | Not Applicable | 8.25
(blank) | (blank) | (blank) | (blank) | Grand Total
Grand Total |  |  |  |  | 1168.75