How do you enter the height and width?

If you use one cell each, then for 5' 6", make sure you enter:
5.5
in the cell (5 and 1/2 feet)
or even
5 6/12

Then you can just multiply the two cells:

=a1*b1
(say).

If you do your entry in inches:

66
for 5.5 feet

then
=a1*b1/144



If you use two cells for each dimension (feet and inches)

A1 = height in feet
b1 = left over inches

=(a1+b1/12)*(c1+d1/12)



PeggyC wrote:

I'm trying to calculate window and door measurements into square feet. Any
suggestions?
Peggy

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


.



--

Dave Peterson