Thanks GerryK, ill use the rounddown function.

"GerryK" wrote:

Not without VBA
Try this:
http://www.mrexcel.com/tip012.shtml
-----Original Message-----
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
.


.