Calculating the Area of objects in Feet and Inches

[Guest]

I am completing a project in which I need to take data collected on window
sizes and calculate the total area. The data is in Feet and Inches. If
possibe I want to be able to plug the data into excell and have it formated
so it displays 2ft 6in but is still in data form.

I have tried to do this by number formating like this #"ft" ?/12"in" but if
I typed in 2 feet and 6 inches (2.6) I get 2ft7/12in in the cell. I realize
why but I don't know how to format it in a way that excell will interpret it
as 2ft6in. Any help would be great.

After entering the height and width that way I want to calculate the area in
one cell. From what I've seen the data has to be converted to decimal form
to cacluate and then I would want the area to be put into feet and inces
again. I don't know how to do this without using many multiple cells, one to
convert it to decimal, another to multiply the area and another to put that
back as square feet.

Please Help

 

[Guest]

Chip Pearson has some instructions on this at his website:

http://www.cpearson.com/excel/fractional.htm

 

[Guest]

Thanks,
That helped some, I changed how I did things now and now my only quesion
is...is there a number formating opition that would let you type in a decimal
form of feet and inches (like 2.06 for 2 feet 6 inches) and have it displayed
as 2ft6in.
As I said before the closest I've come is typing #"ft" ?/12"in" but then I
get 2ft7/12in, not 6.

 

[Ron Rosenfeld]

I am completing a project in which I need to take data collected on window
sizes and calculate the total area. The data is in Feet and Inches. If
possibe I want to be able to plug the data into excell and have it formated
so it displays 2ft 6in but is still in data form.

I have tried to do this by number formating like this #"ft" ?/12"in" but if
I typed in 2 feet and 6 inches (2.6) I get 2ft7/12in in the cell. I realize
why but I don't know how to format it in a way that excell will interpret it
as 2ft6in. Any help would be great.

After entering the height and width that way I want to calculate the area in
one cell. From what I've seen the data has to be converted to decimal form
to cacluate and then I would want the area to be put into feet and inces
again. I don't know how to do this without using many multiple cells, one to
convert it to decimal, another to multiply the area and another to put that
back as square feet.

Please Help

If you enter your numbers as, for example, 2.06 for 2ft. 6in. you can do a
custom format of:

0"ft". 00" in."

(Note the position of the decimal point, and the absence of a period after the
ft)

to have it show that way.

To obtain area in sq. ft., you can use the formula:

=(INT(A1)+MOD(A1,1)/12*100)*(INT(A2)+MOD(A2,1)/12*100)

where

A1: height
A2: width

And the result could be formatted as

0.000" sq. ft."


--ron

 

[RagDyeR]

See if this page of David McRitchie's helps:

http://www.mvps.org/dmcritchie/excel/formula.htm#carpentry

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Thanks,
That helped some, I changed how I did things now and now my only quesion
is...is there a number formating opition that would let you type in a
decimal
form of feet and inches (like 2.06 for 2 feet 6 inches) and have it
displayed
as 2ft6in.
As I said before the closest I've come is typing #"ft" ?/12"in" but then I
get 2ft7/12in, not 6.

 

[Guest]

to show feet and inches as you would normally write them set your custom
number format like this ##_"ft"_#0_??/??_"in".Of course you can write 2 ft 20
5/8in,but i assume you will only write real measurements

 

[Guest]

Thanks Ron,

that worked perfect. The Website from Ragdye helped too.

Scott