Adding up in old distance's...

[Zider Drinker]

I'm trying to adding different cells together but in an old distance format.
I'm using Miles and Chains!

I'm typing the number as a decimal so hence 2.43 is 2 miles 43 chains.

Now the problem I have is there is only 80 chains in 1 mile. So even when
using a separate column it adds up wrong.

EG

A1 contains 2.43
A2 contains 5.74

Adding the two together Excel gives me 8.17... But the answer I require is
actually 8.37 (8 miles & 37 chains)

Does anyone know if its possible to get excel to do this?

 

[Rick Rothstein]

This seems to do what you want...

=INT(A1)+INT(A2)+INT(5*(MOD(A1,1)+MOD(A2,1))/4)+MOD(100*(MOD(A1,1)+MOD(A2,1)),80)/100