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
.
|