# Thread: Feet and Inches (XP)

1. ## Feet and Inches (XP)

It's me - again! I have a multitude of sheets of paper with measurements of rooms. The measurements are, for example, 30'4" x 24' 3" - I need a formula that will look at these numbers and calculate the square feet of this space.

Can someone help me?

Aunt Linda

2. ## Re: Feet and Inches (XP)

<img src=/S/hello.gif border=0 alt=hello width=25 height=29> Aunt Linda

When will you be visiting us this summer, with the fruit cake in hand... Oh <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15> different Aunt Linda.

OK you say that you have these cells with these measurements, are they entered as text, or complex numbers?

To get the square footage, well you multiply the length by the width, its as simple as that, but then if 30'4 is entered as text, then you need to convert it to numbers, and then do the multiplication. Maybe you can also look at the <font color=red> CONVERT </font color=red> function maybe you want to see it all in feet or inches.

Hope this helps...

Wassim

3. ## Re: Feet and Inches (XP)

Here is a formula that will work if you always use that form.
=(VALUE(MID(A1,1,FIND("'",A1)-1))+VALUE(MID(A1,FIND("'",A1)+1,FIND(CHAR(34),A1)-FIND("'",A1)-1))/12)*(VALUE((MID(A1,FIND("x",A1)+1,FIND("'",A1,FIND ("x",A1))-FIND("x",A1)-1)))+VALUE((MID(A1,FIND("'",A1,FIND("x",A1))+1,FIN D(CHAR(34),A1,FIND("x",A1))-FIND("'",A1,FIND("x",A1))-1)))/12)

You might have to create a custom function if you have different forms (the formula I propose does REQUIRE both FEET and INCHES for measurements. You can not have 12' x 6" you must have 12'0" x 0'6".

A custom function could get around that. The biggest problem is deciding on all the different variants to check for.

Steve

4. ## Re: Feet and Inches (XP)

I thought about your request again. You mention "sheets of paper" with the implication that they are NOT yet in a spreadsheet?
If not enter them in separate columns:
Col A: Length Ft portion
Col B: Length inch portion
Col C: Width Ft portion
Col D: Width inch portion

Then the formula:
<pre>=(A1+B1/12)*(C1+D1/12)</pre>

will give you square feet directly.
If you want this "separated form" into the form you list:
Something like this will work:
=IF(A1=0,"",A1&"' ")&IF(B1=0,"",B1&CHAR(34))&" "&CHAR(215)&" "&IF(C1=0,"",C1&"' ")&IF(D1=0,"",D1&CHAR(34))

This equation will eliminate the 0" or 0' from the display.

Steve

5. ## Re: Feet and Inches (XP)

I was referring to actual PAPER. And - I'm sorry I didn't post this yesterday - I did have the "duh" moment when I said to myself, "Self, you knot-head, just put the feet and inches into separate columns and then write this really simple formula." So I did - and it's all good now.

Thanks for thinking about me - the fruit cake is in the mail.

Aunt Linda

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•