Desperate! Square footage formula?

[petice]

Hi All,
Miss desperate here. I am trying to create a spreadsheet that automatically calculates the square footage of room measurements when they're entered as such: 7.1 X 12.4 (meaning-7 feet, 1 inch X 12feet, 4 inches) I've searched the board and cannot find anything.
Got any ideas???

 

[Tazguy37]

How's this?:

Book1
	A	B	C	D
1	Dimensions (ft.in)	Feet		Square feet
2	7.1	7.008333333		84.33361111
3	12.4	12.03333333
Sheet3

Formulas:
B1 (copied down): =INT(A2)+(A2-INT(A2))/12

D1: =B2*B3

Hope that helps!

 

[Scott Huish]

Taz, I think there's a slight error in your calculations:

From 12.4, it should be 4/12 not .4/12

 

[bosshogg]

they're entered as such: 7.1 X 12.4

Are the dimensions really entered as "7.1 X 12.4" ? As in all in one cell? You'll need to pull out the length and width portion of the string then apply Taz's formula dividing by 1.2 rather than 12.

 

[Tazguy37]

You're right, HOTPEPPER, I missed a decimal in there.

So that should be (this is reducible, of course):
=INT(A2)+10*(A2-INT(A2))/12

This is what happens when they make you work 12-hour days, 6 days a week for 3 weeks (so far ).

 

[petice]

Square Footage - Yikes I should have explained better

Column A, Row 1 is the first measurement
Column B Row 1 is the second measurment
Column C, Row 1 should have the square footage of both measurments together.
I don't know how to put up a spreadsheet example on this site.

 

[Scott Huish]

Possibly:

=((MOD(A1,1)/1.2)+INT(A1))*((MOD(B1,1)/1.2)+INT(B1))

Copy down.

 

[Tazguy37]

Try:

=(INT(A1)+10*(A1-INT(A1))/12)*(INT(B1)+10*(B1-INT(B1))/12)

 

[PA HS Teacher]

projectile1.xls
	A	B	C	D	E
1	Length	Width	Sqft	Length	Width
2	2.11	3.4	18.47222	2.916667	6.333333
Sheet3

What about 2.11
.11 is between .1 and .2, it's not bigger than .9

In C1:
=(INT(A2)+RIGHT(TEXT(A2,".00"),2)/12)*(INT(B2)+RIGHT(TEXT(B2,".00"),2)/12)

Or to simply convert to decimal feet in D1:
=INT(A2)+RIGHT(TEXT(A2,".00"),2)/12

 

[Scott Huish]

What happens with fractional inches, say 5-3/4 inches?