I have a spreadsheet,section attached.

In column a is the distance in miles and furlongs and yards..sometimes there is only miles..sometimes only miles and furlongs,,sometimes only miles and yards..

I need a formula i can fill down in column b to convert to furlongs in decimal format

e.g. 2miles 3 furlongs and 20 yards converts to 19.09 furlongs..

there are 8 furlongs in a mile and 220 yards in a furlong...

In column a is the distance in miles and furlongs and yards..sometimes there is only miles..sometimes only miles and furlongs,,sometimes only miles and yards..

I need a formula i can fill down in column b to convert to furlongs in decimal format

e.g. 2miles 3 furlongs and 20 yards converts to 19.09 furlongs..

there are 8 furlongs in a mile and 220 yards in a furlong...

## Comment