function to convert inches

  • Thread starter Thread starter Tom Gasting
  • Start date Start date
T

Tom Gasting

Anyone have a custom function to convert inches to square footage?

Say I have a floor area 157 1/8 by 256 1/2 inchs.What could I use to
break that into total feet and remainder inches?
 
Hi Tom,

It depends on how your data is stored in the cells. If each measurement is
stored as a number of inches (with decimal or fractional part in the same
cell), then you could do something like this to find the square footage of
an area defined by sides A1 and A2:

Square Feet:
=A1*A2/144

**OR**

Whole Square Feet:
=FLOOR(A1*A2/144,1)

Fractional Square Inches:
=MOD(A1*A2/144,1)*12

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
try this where h7 has one measurement and h8 another.
=CONVERT(H7,"in","ft")*CONVERT(H8,"in","ft")
 
Tom,

Not certain exactly what you want---sqr feet or feet and inches
To get feet and inches from inches in say A1
In B1 =INT(A1/12) gives you feet
In C1 =A1 -(12*B1) gives you the remainder inches

To get sqr feet from two inch amounts in say A2 &B2
In C2 =A2 * B2/144 There are 144 sqr inches in 1 sqr foot.

HTH
Henry
 
Back
Top