Need formulas for adding feet, inches & fraction in one cell

[Wayne hof]

If i have 12' 4" & 1/2" in cell A1 and 10' 4" &1/4" in cell A2 how do i add
or subtract them? Will excel do this or Is there a program/script or
something that will do this.

 

[Biff]

Hi!

This could be done in the format that you have:

12' 4" & 1/2"

but the resulting formula would be a real mess!

Suggestion: drop the fraction for a decimal and get rid of
the ampersand so that the entry looks like this:

12' 4.5"

Now, use this formula to convert the measure to inches:

=(LEFT(A1,FIND("'",A1)-1)*12+SUBSTITUTE(MID(A1,FIND(" ",A1)
+1,255),"""",""))

You can perform whatever math operations you need on the
converted values and then convert them back to feet inches
with this formula:

=ROUND(INT(B1)/12,0)&"' "&MOD(B1,12)&""""

Biff