Addition in base 6

Hi,

I've got a column of numbers that represent the number of overs bowled in games of cricket. Whilst these are whole numbers (eg. 34 overs + 34 overs) the addition isn't a problem, but when they are incomplete overs (eg. 34.4 overs + 34.5 overs) then the addition if out of kilter as it sums them in base 10, and not in base 6. (As there are six balls in an over, not ten for anyone who doesn't know!)

Anyone know a formula for this or was round it? Ta

If we assume

A1: 34
A2: 34.5
A3: 33.2

Sum of 102.1

A4: =DOLLARFR(SUMPRODUCT((INT(A1:A3)*6)+(MOD(A1:A3,1)*10))/6,6)

In my experience it's often easier to store the overs as balls bowled in an adjacent cell... ie:

B1: =(INT(A1)*6)+(MOD(A1,1)*10)

Then SUM the deliveries and divide by 6... then use DOLLARFR to return the decimal remainder into base 6 value, ie

B4: =DOLLAFR(SUM(B1:B3)/6,6)