I currently have this for the remaining of the column a new row which is blank and thats where i want the sum totals to go for In and Trans:
Store Date Hour In Out Trans Sales Hours CR %
3 20110808 10 17 8 6 7 35.29%
3 20110808 11 33 30 3 7 9.09%
3 20110808 12 45 48 9 8.68 20.00%
3 20110808 13 73 77 7 7.9 9.59%
3 20110808 14 68 64 11 7.77 16.18%
3 20110808 15 55 52 9 8 16.36%
3 20110808 16 51 50 3 8 5.88%
3 20110808 17 47 47 4 7.05 8.51%
3 20110808 18 23 24 2 7 8.70%
3 20110808 19 28 22 1 7 3.57%
3 20110808 20 22 35 1 6.77 4.55%
3 20110808 21 1 2 0 0 0.00%

3 20110809 10 13 7 7 3.9 53.85%
3 20110809 11 42 43 9 4 21.43%
3 20110809 12 60 61 8 4.35 13.33%
3 20110809 13 56 55 19 5.87 33.93%
3 20110809 14 89 91 10 6 11.24%
3 20110809 15 75 73 6 6 8.00%
3 20110809 16 43 49 3 5.63 6.98%
3 20110809 17 39 42 3 4.77 7.69%
3 20110809 18 19 31 2 4.98 10.53%
3 20110809 19 34 31 7 5 20.59%
3 20110809 20 23 26 0 4.25 0.00%

3 20110810 10 12 7 3 7 25.00%
3 20110810 11 42 40 6 7.02 14.29%
3 20110810 12 43 43 7 8 16.28%
3 20110810 13 17 24 3 8 17.65%
3 20110810 14 61 69 3 7.25 4.92%
3 20110810 15 41 45 4 6.3 9.76%
3 20110810 16 33 34 7 6.93 21.21%
3 20110810 17 43 54 11 5.92 25.58%
3 20110810 18 41 47 4 5.68 9.76%
3 20110810 19 51 54 5 6 9.80%
3 20110810 20 13 24 0 5.18 0.00%

3 20110811 10 11 8 6 4.8 54.55%
3 20110811 11 46 44 5 5.07 10.87%
3 20110811 12 30 24 5 6.57 16.67%
3 20110811 13 34 42 11 6.82 32.35%
3 20110811 14 82 83 7 6.63 8.54%
3 20110811 15 52 43 9 5.55 17.31%
3 20110811 16 57 63 7 4 12.28%
3 20110811 17 46 51 10 4.27 21.74%
3 20110811 18 56 59 3 4 5.36%
3 20110811 19 54 52 1 4 1.85%
3 20110811 20 15 14 0 3.22 0.00%

3 20110812 10 25 23 5 4 20.00%
3 20110812 11 33 51 5 3.78 15.15%
3 20110812 12 66 59 14 5.13 21.21%
3 20110812 13 63 67 8 6.53 12.70%
3 20110812 14 69 74 9 5.62 13.04%
3 20110812 15 73 73 10 5.18 13.70%
3 20110812 16 100 90 5 4.02 5.00%
3 20110812 17 76 76 8 3.4 10.53%
3 20110812 18 54 49 5 3.05 9.26%
3 20110812 19 37 38 3 3 8.11%
3 20110812 20 18 24 1 3 5.56%
3 20110812 21 2 5 0 0.1 0.00%