Major Chart Correction:
| | Cash 3 | AB-12 | BC-12 | BA-12 | CB-12 | AB+12 | BC+12 | BA+12 | CB+12 | Cash 4 | Numbers |
19-Apr | Midday | 416 | 29 | 4 | 2 | 49 | 53 | 28 | 26 | 73 | 0339 | |
18-Apr | Evening | 143 | 2 | 31 | 29 | 22 | 26 | 55 | 53 | 46 | 2055 | 2055/0339/416 |
18-Apr | Midday | 138 | 1 | 26 | 19 | 71 | 25 | 50 | 43 | 95 | 9655 | 143/2055/416 |
17-Apr | Evening | 662 | 54 | 50 | 54 | 14 | 78 | 74 | 78 | 38 | 3804 | 3804/138 |
17-Apr | Midday | 522 | 40 | 10 | 13 | 10 | 64 | 34 | 37 | 34 | 8405 | |
16-Apr | Evening | 108 | 98 | 96 | 89 | 68 | 22 | 20 | 13 | 92 | 8231 | 8231 |
15-Apr | Evening | 759 | 63 | 47 | 45 | 83 | 87 | 71 | 69 | 7 | 1326 | |
15-Apr | Midday | 856 | 73 | 44 | 46 | 53 | 97 | 68 | 70 | 77 | 4429 | 759/8405 |
14-Apr | Evening | 828 | 70 | 16 | 16 | 70 | 94 | 40 | 40 | 94 | 9361 | |
14-Apr | Midday | 802 | 68 | 90 | 96 | 8 | 92 | 14 | 20 | 32 | 4065 | 828/9361 |
13-Apr | Evening | 831 | 71 | 19 | 26 | 1 | 95 | 43 | 50 | 25 | 6043 | 6043/4065/9361 |
13-Apr | Midday | 303 | 18 | 91 | 91 | 18 | 42 | 15 | 15 | 42 | 9410 | |
12-Apr | Evening | 248 | 12 | 36 | 30 | 72 | 36 | 60 | 54 | 96 | 8250 | 303/9410/6043 |
12-Apr | Midday | 803 | 68 | 91 | 96 | 18 | 92 | 15 | 20 | 42 | 9483 | 248/8250 |
Major Correction:
After reading a little bit of Cashman87 post, I realize I did not adjust for over 100/under 0. These formulas will adjust as needed to provide the required number and perhaps even make it easier to deal with.
For those who want the Excel formula, below are the formulas for each column;
AB-12=IF(((LEFT($C21,2)*1))>11,TEXT(SUM(LEFT($C21,2)*1)-12,"##"),TEXT(SUM(LEFT($C21,2)*1)-12+100,"##"))
BC-12=IF(((RIGHT($C21,2)*1))>11,TEXT(SUM(RIGHT($C21,2)*1)-12,"##"),TEXT(SUM(RIGHT($C21,2)*1)-12+100,"##"))
BA-12=IF(((CONCATENATE((MID($C21,2,1)),(LEFT($C21,1))))*1)>11,TEXT(SUM(((CONCATENATE((MID($C21,2,1)),(LEFT($C21,1))))*1)-12),"##"),TEXT(SUM(((CONCATENATE((MID($C21,2,1)),(LEFT($C21,1))))*1)-12+100),"##"))
CB-12
=IF(((CONCATENATE((RIGHT($C21,1)),(MID($C21,2,1))))*1)>11,TEXT((SUM(CONCATENATE((RIGHT($C21,1)),(MID($C21,2,1))))*1)-12,"##"),TEXT((SUM(CONCATENATE((RIGHT($C21,1)),(MID($C21,2,1))))*1)-12+100,"##"))
AB+12=IF((D21+24)>99,(D21+24-100),(D21+24))
BC+12=IF((E21+24)>99,(E21+24-100),(E21+24))
BA+12=IF((F21+24)>99,(F21+24-100),(F21+24))
CB+12=IF((G21+24)>99,(G21+24-100),(G21+24))
($C21 is the cell with the Cash 3 number in it)
Good Luck
Sir Metro