How Can i sum hectars ?
Best In VBA otherwise in formulas.

I have a situation like this ...

Hectars, Areas, Cent/Areas

--|----------|
| A |
--|----------|
1 | 16 47 83 |
--|----------|
2 | 23 40 30 |
--|----------|
3 | 39 88 13 |
--|----------|

Total has to be 39 88 13 ( not 06 87 113 ).



Any Help ?

Best Regards.

Robert.