So theres no way to format data for particular cells as feet,inches persay?
IE cell A1 is 12"4" and cell B1 is 12' 8" and formula for cell c1 would be
Sum(a1,b2).

"GerryK" wrote:

If you convert your data to inches you can use:
ROUNDDOWN(A1/12,0)&" feet "&A1-12*ROUNDDOWN(A1/12,0)&"
inches"

Try putting inches (your result) in A1 for this example.

-----Original Message-----
How do you add or subtract feet & inches in formulas IE
12' 4" + 12' 8"...
--
Wayne Hof
.