I've refrased my question in another post just now. Im trying to find
diferances in elevation for surveying a floor. What I'd like to do is --- In
cell A1 12' 4" &1/2". in cell A2 put 12'3"&3/4 then find the differance(but
with many more "before & after" measurements).

"Don Guillett" wrote:

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