Working With Feet And Inches In Excel
Excel doesn't provide any built in means to work with
measurements in feet and inches. It treats a representation of feet and
inches such as 5'10"
as simply a text string, and as such, cannot do any arithmetic operations
like addition and subtraction with it. To work with feet and inches, you
need to convert the text string to a numeric value that Excel can use.
The formula below will convert the text string in cell
A1 to a decimal value that Excel can use for arithmetic operations:
The input string to this function should not contain spaces or other characters. This formula can be used as
an array formula to sum up a range of values:
For a VBA based solution, use the following function:
See also my page on Fractional Arithmetic.