Spreadsheet: 157170d1337638949-excel-2010-need-help-with-sumtotal-macro-sum-total-macro-furum-question-5-21-2012
Sheet: feed file

Payroll  Start Date: '25-APR-2012', End Date: '09-MAY-2012'
Employee # | Work Date | Work Day | DFM Code | Start Session1 | End Session1 | Start Session 2 | End Session2 | Break1 | Break2 | Paid Hours | OT Hours | Scheduled OPI Minutes | Unscheduled OPI Minutes | EWD | Interpretertype
2012 | 2012-04-25 00:00:00 | Wed |  | 0600 | 1000 | 1030 | 1430 | 0815 | 1200 | 8 |  | 326.5 | 0 | 8 | CSI
 | 2012-04-26 00:00:00 | Thu |  | 0600 | 0945 | 1015 | 1430 | 0730 | 1215 | 8 |  | 355.5 | 0 | 8 | CSI
 | 2012-04-27 00:00:00 | Fri |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1200 | 8 |  | 341.3 | 0 | 8 | CSI
 | 2012-04-28 00:00:00 | Sat |  | 0600 | 1030 | 1100 | 1430 | 0730 | 1245 | 8 |  | 317 | 0 | 8 | CSI
 | 2012-04-29 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-04-30 00:00:00 | Mon |  | 0600 | 1015 | 1045 | 1430 | 0730 | 1230 | 8 |  | 339.7 | 0 | 8 | CSI
 | 2012-05-01 00:00:00 | Tue |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1145 | 8 |  |  |  | 8 | CSI
 |  | Tue | UTO | 0600 | 0900 |  |  |  |  |  |  |  |  | 8 | CSI
 |  | Tue | AS | 0900 | 1430 |  |  |  |  |  |  |  |  | 8 | CSI
 | 2012-05-02 00:00:00 | Wed |  | 0600 | 1000 | 1030 | 1430 | 0800 | 1200 | 8 |  | 365.1 | 0 | 8 | CSI
 | 2012-05-03 00:00:00 | Thu |  | 0600 | 0945 | 1015 | 1430 | 0730 | 1145 | 8 |  | 307.8 | 0 | 8 | CSI
 | 2012-05-04 00:00:00 | Fri |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1145 | 8 |  | 367.7 | 0 | 8 | CSI
 | 2012-05-05 00:00:00 | Sat |  | 0600 | 1015 | 1045 | 1430 | 0730 | 1245 | 8 |  | 328.6 | 4.600000000000001 | 8 | CSI
 | 2012-05-06 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1145 | 8 |  | 373.4 | 6.2 | 8 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1145 | 8 |  | 333.9 | 0 | 8 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 0600 | 1000 | 1030 | 1430 | 0800 | 1200 | 0 |  |  |  | 8 | CSI
 |  | Wed | AE | 0600 | 1000 |  |  |  |  |  |  |  |  | 8 | CSI
 |  | Wed | AP | 1000 | 1430 |  |  |  |  |  |  |  |  | 8 | CSI
Total |  |  |  |  |  |  |  |  |  | 88 |  | 3756.5 | 10.8
2014 | 2012-04-25 00:00:00 | Wed |  | 1400 | 2000 |  |  | 1700 | 1715 | 6 |  | 228.1 | 0 | 8 | CSI
 | 2012-04-26 00:00:00 | Thu |  | 1130 | 1515 | 1545 | 2000 | 1300 | 1815 | 8 |  | 313.6 | 0 | 8 | CSI
 | 2012-04-27 00:00:00 | Fri |  | 1130 | 1615 | 1645 | 2000 | 1315 | 1815 | 7 |  | 268.7 | 0 | 8 | CSI
 | 2012-04-28 00:00:00 | Sat |  | 1130 | 1545 | 1615 | 2000 | 1400 | 1800 | 8 |  | 286.2 | 2.2 | 8 | CSI
 | 2012-04-29 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-04-30 00:00:00 | Mon |  | 1130 | 1615 | 1645 | 2000 | 1315 | 1815 | 8 |  | 283.7 | 0 | 8 | CSI
 | 2012-05-01 00:00:00 | Tue |  | 1130 | 1615 | 1645 | 2000 | 1315 | 1815 | 8 |  | 314.2 | 0 | 8 | CSI
 | 2012-05-02 00:00:00 | Wed |  | 1400 | 2000 |  |  | 1645 | 1700 | 6 |  | 230.2 | 0 | 8 | CSI
 | 2012-05-03 00:00:00 | Thu |  | 1130 | 1615 | 1645 | 2000 | 1300 | 1815 | 8 |  | 261.7 | 0 | 8 | CSI
 | 2012-05-04 00:00:00 | Fri |  | 1130 | 1545 | 1615 | 2000 | 1300 | 1815 | 8 |  | 305.1 | 3.6 | 8 | CSI
 | 2012-05-05 00:00:00 | Sat |  | 1130 | 1545 | 1615 | 2000 | 1345 | 1815 | 8 |  | 198 | 4.9 | 8 | CSI
 | 2012-05-06 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 1130 | 1515 | 1545 | 2000 | 1300 | 1815 | 7.75 |  | 298.3 | 0 | 8 | CSI
 |  | Mon | AO | 1145 | 1200 |  |  |  |  |  |  |  |  | 8 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 1130 | 1515 | 1545 | 2000 | 1300 | 1815 | 8 |  | 282.3 | 0 | 8 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 1400 | 2000 |  |  | 1700 | 1715 | 6 |  | 237.5 | 0 | 8 | CSI
Total |  |  |  |  |  |  |  |  |  | 96.75 |  | 3507.6 | 10.7
4269 | 2012-04-25 00:00:00 | Wed | DO |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-04-26 00:00:00 | Thu | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-04-27 00:00:00 | Fri | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-04-28 00:00:00 | Sat | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-04-29 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-04-30 00:00:00 | Mon | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-05-01 00:00:00 | Tue | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-05-02 00:00:00 | Wed | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-05-03 00:00:00 | Thu | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-05-04 00:00:00 | Fri | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-05-05 00:00:00 | Sat | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-05-06 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-05-07 00:00:00 | Mon | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-05-08 00:00:00 | Tue | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
 | 2012-05-09 00:00:00 | Wed | NA |  |  |  |  |  |  | 0 |  |  |  | 5 | CSI
Total |  |  |  |  |  |  |  |  |  | 0
4280 | 2012-04-25 00:00:00 | Wed |  | 1400 | 1800 |  |  | 1545 |  | 4 |  | 179.2 | 0 | 4 | CSI
 | 2012-04-26 00:00:00 | Thu |  | 1400 | 1800 |  |  | 1545 |  | 4 |  | 188.1 | 0 | 4 | CSI
 | 2012-04-27 00:00:00 | Fri |  | 1400 | 1800 |  |  | 1545 |  | 4 |  | 178.8 | 6.3 | 4 | CSI
 | 2012-04-28 00:00:00 | Sat | DO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-04-29 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-04-30 00:00:00 | Mon | UTO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-05-01 00:00:00 | Tue | UTO |  |  |  |  |  |  | 4 |  |  |  | 4 | CSI
 | 2012-05-02 00:00:00 | Wed | UTO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-05-03 00:00:00 | Thu | UTO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-05-04 00:00:00 | Fri | UTO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-05-05 00:00:00 | Sat | DO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-05-06 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 1400 | 1800 |  |  | 1600 |  | 4 |  | 183 | 0 | 4 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 1400 | 1800 |  |  | 1545 |  | 4 |  | 161.4 | 0 | 4 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 1400 | 1800 |  |  | 1545 |  | 4 |  | 178.7 | 0 | 4 | CSI
Total |  |  |  |  |  |  |  |  |  | 24 |  | 1069.2 | 6.3
12151 | 2012-04-25 00:00:00 | Wed |  | 0600 | 1000 |  |  | 0800 |  | 4 |  | 140.4 | 0 | 4 | CSI
 | 2012-04-26 00:00:00 | Thu |  | 0600 | 1000 |  |  | 0800 |  | 4 |  | 178.1 | 0 | 4 | CSI
 | 2012-04-27 00:00:00 | Fri |  | 0600 | 1000 |  |  | 0745 |  | 4 |  | 187.9 | 0 | 4 | CSI
 | 2012-04-28 00:00:00 | Sat | DO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-04-29 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-04-30 00:00:00 | Mon |  | 0600 | 1200 |  |  | 0845 | 0900 | 6 |  | 278.9 | 0 | 4 | CSI
 | 2012-05-01 00:00:00 | Tue |  | 0600 | 1000 |  |  | 0800 |  | 4 |  | 143.3 | 0 | 4 | CSI
 | 2012-05-02 00:00:00 | Wed |  | 0600 | 1000 |  |  | 0800 |  | 4 |  | 150 | 0 | 4 | CSI
 | 2012-05-03 00:00:00 | Thu |  | 0600 | 1000 |  |  | 0800 |  | 4 |  | 168.5 | 0 | 4 | CSI
 | 2012-05-04 00:00:00 | Fri | UTO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-05-05 00:00:00 | Sat | DO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-05-06 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 4 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 0600 | 1000 |  |  | 0800 |  | 3.5 |  | 169.3 | 5 | 4 | CSI
 |  | Mon | AE | 0930 | 1000 |  |  |  |  |  |  |  |  | 4 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 0600 | 1000 |  |  | 0800 |  | 4 |  | 161.5 | 0 | 4 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 0600 | 1000 |  |  | 0800 |  | 4 |  | 163.8 | 0 | 4 | CSI
Total |  |  |  |  |  |  |  |  |  | 41.5 |  | 1741.7 | 5
12154 | 2012-04-25 00:00:00 | Wed |  | 0600 | 0945 | 1015 | 1430 | 0730 | 1145 | 8 |  | 310.3 | 0 | 8 | CSI
 | 2012-04-26 00:00:00 | Thu |  | 0600 | 0945 | 1015 | 1430 | 0745 | 1145 | 8 |  | 293.4 | 0 | 8 | CSI
 | 2012-04-27 00:00:00 | Fri |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1200 | 8 |  | 352.3 | 3.9 | 8 | CSI
 | 2012-04-28 00:00:00 | Sat |  | 0600 | 1200 |  |  | 0845 | 0900 | 6 |  | 268.7 | 0 | 8 | CSI
 | 2012-04-29 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-04-30 00:00:00 | Mon |  | 0600 | 0945 | 1015 | 1430 | 0730 | 1145 | 8 |  | 350.9 | 0 | 8 | CSI
 | 2012-05-01 00:00:00 | Tue |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1200 | 8 |  | 331.6 | 0 | 8 | CSI
 | 2012-05-02 00:00:00 | Wed |  | 0600 | 1000 | 1030 | 1430 | 0800 | 1200 | 8 |  | 349.6 | 9.5 | 8 | CSI
 | 2012-05-03 00:00:00 | Thu |  | 0600 | 0945 | 1015 | 1430 | 0730 | 1145 | 8 |  | 340.3 | 0 | 8 | CSI
 | 2012-05-04 00:00:00 | Fri |  | 0600 | 0945 | 1015 | 1430 | 0730 | 1145 | 8 |  | 266.1 | 0 | 8 | CSI
 | 2012-05-05 00:00:00 | Sat |  | 0600 | 1200 |  |  | 0900 | 0915 | 6 |  | 220.2 | 0 | 8 | CSI
 | 2012-05-06 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1145 | 8 |  | 320.3 | 19.6 | 8 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 0600 | 0945 | 1015 | 1430 | 0745 | 1145 | 8 |  | 315.5 | 0 | 8 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1145 | 8 |  | 330.5 | 0 | 8 | CSI
Total |  |  |  |  |  |  |  |  |  | 100 |  | 4049.7 | 33
12262 | 2012-04-25 00:00:00 | Wed |  | 0600 | 1015 | 1045 | 1430 | 0815 | 1215 | 8 |  | 335.3 | 0 | 8 | CSI
 | 2012-04-26 00:00:00 | Thu |  | 0600 | 0945 | 1015 | 1430 | 0730 | 1230 | 8 |  | 347.9 | 0.9 | 8 | CSI
 | 2012-04-27 00:00:00 | Fri |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1145 | 8 |  | 371.7 | 1.5 | 8 | CSI
 | 2012-04-28 00:00:00 | Sat | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-04-29 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-04-30 00:00:00 | Mon |  | 0600 | 0945 | 1015 | 1430 | 0730 | 1145 | 8 |  | 390.3 | 8 | 8 | CSI
 | 2012-05-01 00:00:00 | Tue |  | 0600 | 1000 | 1030 | 1430 | 0730 | 1200 | 8 |  | 276.9 | 0 | 8 | CSI
 | 2012-05-02 00:00:00 | Wed |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1200 | 8 |  | 359.1 | 30 | 8 | CSI
 | 2012-05-03 00:00:00 | Thu |  | 0600 | 1015 | 1045 | 1430 | 0830 | 1215 | 8 |  | 344.5 | 0 | 8 | CSI
 | 2012-05-04 00:00:00 | Fri |  | 0600 | 0945 | 1015 | 1430 | 0800 | 1145 | 8 |  | 362 | 1.5 | 8 | CSI
 | 2012-05-05 00:00:00 | Sat | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-05-06 00:00:00 | Sun | DO |  |  |  |  |  |  | 0 |  |  |  | 8 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 0600 | 1015 | 1045 | 1430 | 0800 | 1230 | 8 |  | 377.1 | 0 | 8 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 0600 | 0945 | 1015 | 1430 | 0730 | 1145 | 8 |  | 334.1 | 0 | 8 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 0600 | 1000 | 1030 | 1430 | 0800 | 1200 | 8 |  | 316 | 0 | 8 | CSI
Total |  |  |  |  |  |  |  |  |  | 88 |  | 3814.9 | 41.9
15206 | 2012-05-01 00:00:00 | Tue |  | 1600 | 1800 |  |  | 1645 |  | 2 |  |  |  | 8 | CSI
 | 2012-05-02 00:00:00 | Wed |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 285.9 | 0 | 8 | CSI
 | 2012-05-03 00:00:00 | Thu |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 228.5 | 0 | 8 | CSI
 |  | Thu | FDBCK | 1445 | 1500 |  |  |  |  |  |  |  |  | 8 | CSI
 | 2012-05-04 00:00:00 | Fri |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 249.4 | 0 | 8 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 256.1 | 0 | 8 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 268.8 | 30 | 8 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 228.8 | 0 | 8 | CSI
Total |  |  |  |  |  |  |  |  |  | 50 |  | 1517.5 | 30
15207 | 2012-05-01 00:00:00 | Tue |  | 1600 | 1800 |  |  | 1645 |  | 2 |  |  |  | 7 | CSI
 | 2012-05-02 00:00:00 | Wed |  | 0930 | 1300 | 1330 | 1700 | 1115 | 1500 | 7 |  | 215.2 | 0 | 7 | CSI
 | 2012-05-03 00:00:00 | Thu |  | 0930 | 1300 | 1330 | 1700 | 1115 | 1500 | 7 |  | 234.9 | 0 | 7 | CSI
 | 2012-05-04 00:00:00 | Fri |  | 0930 | 1300 | 1330 | 1700 | 1115 | 1500 | 7 |  | 239.4 | 0 | 7 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 0930 | 1300 | 1330 | 1700 | 1115 | 1500 | 7 |  | 247.4 | 0 | 7 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 0930 | 1300 | 1330 | 1700 | 1115 | 1500 | 7 |  | 225.9 | 0 | 7 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 0930 | 1300 | 1330 | 1700 | 1115 | 1500 | 7 |  | 216.5 | 0 | 7 | CSI
Total |  |  |  |  |  |  |  |  |  | 44 |  | 1379.3 | 0
15209 | 2012-05-01 00:00:00 | Tue |  | 1600 | 1800 |  |  | 1645 |  | 2 |  |  |  | 6 | CSI
 | 2012-05-02 00:00:00 | Wed |  | 0730 | 1330 |  |  | 1015 | 1030 | 6 |  | 96 | 0 | 6 | CSI
 | 2012-05-03 00:00:00 | Thu |  | 0730 | 1330 |  |  | 1015 | 1030 | 6 |  | 140 | 0 | 6 | CSI
 | 2012-05-04 00:00:00 | Fri |  | 0730 | 1330 |  |  | 1015 | 1030 | 6 |  | 179.1 | 11.3 | 6 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 0730 | 1330 |  |  | 1015 | 1030 | 5 |  | 142.5 | 0 | 6 | CSI
 |  | Mon | AS | 1230 | 1330 |  |  |  |  |  |  |  |  | 6 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 0730 | 1330 |  |  | 1015 | 1030 | 6 |  | 127.4 | 0 | 6 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 0730 | 1330 |  |  | 1015 | 1030 | 6 |  | 148.1 | 0 | 6 | CSI
Total |  |  |  |  |  |  |  |  |  | 37 |  | 833.1 | 11.3
15210 | 2012-05-01 00:00:00 | Tue |  | 1600 | 1800 |  |  | 1645 |  | 2 |  |  |  | 8 | CSI
 | 2012-05-02 00:00:00 | Wed |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 0 |  |  |  | 8 | CSI
 |  | Wed | TEL | 0830 | 1700 |  |  |  |  |  |  |  |  | 8 | CSI
 | 2012-05-03 00:00:00 | Thu |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 262.3 | 0 | 8 | CSI
 | 2012-05-04 00:00:00 | Fri |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 256.2 | 0 | 8 | CSI
 | 2012-05-07 00:00:00 | Mon |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 261.2 | 0 | 8 | CSI
 | 2012-05-08 00:00:00 | Tue |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 257.3 | 12.7 | 8 | CSI
 | 2012-05-09 00:00:00 | Wed |  | 0830 | 1215 | 1245 | 1700 | 1000 | 1400 | 8 |  | 259.5 | 0 | 8 | CSI
Total |  |  |  |  |  |  |  |  |  | 42 |  | 1296.5 | 12.7