Calculate formulas with feet & inches

G

GerryK

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

Wayne hof

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 said:
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.
Click to expand...
 
W

Wayne hof

Thanks for the website, good info, gets me close the formula i need, now i
just need to deal with the fractional part if i have 1/2"...
 
D

Don Guillett

This formula converts to inches & does square feet. You can adapt for your
need.
Feet Inches Feet Inches Sq Ft Price Square
Feet

15 9 18 8 $ 3.87 294.000

=(C6+IF(D6<>" ",D6/12,0))*(E6+IF(F6<>" ",F6/12,0))
 
W

Wayne hof

I've refrased my question in another post just now. Im trying to find
diferances in elevation for surveying a floor. What I'd like to do is --- In
cell A1 12' 4" &1/2". in cell A2 put 12'3"&3/4 then find the differance(but
with many more "before & after" measurements).
 
P

PeggyC

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

Dave Peterson

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)
 
Top