This formula converts to inches & does square feet. You can adapt for your
need.
Feet Inches Feet Inches Sq Ft Price Square
Feet

15 9 18 8 $ 3.87 294.000

=(C6+IF(D6<" ",D6/12,0))*(E6+IF(F6<" ",F6/12,0))

--
Don Guillett
SalesAid Software

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