Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate formulas with feet & inches
How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"...
-- Wayne Hof |
#2
|
|||
|
|||
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. -----Original Message----- How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof . |
#3
|
|||
|
|||
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" wrote: 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. -----Original Message----- How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof . |
#4
|
|||
|
|||
Not without VBA
Try this: http://www.mrexcel.com/tip012.shtml -----Original Message----- 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" wrote: 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. -----Original Message----- How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof . . |
#5
|
|||
|
|||
Thanks GerryK, ill use the rounddown function.
"GerryK" wrote: Not without VBA Try this: http://www.mrexcel.com/tip012.shtml -----Original Message----- 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" wrote: 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. -----Original Message----- How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof . . |
#6
|
|||
|
|||
http://www.cpearson.com/excel/fractional.htm
Chip has some info on DOLLARDE and DOLLARFR you may find useful for this. HTH -----Original Message----- Thanks GerryK, ill use the rounddown function. "GerryK" wrote: Not without VBA Try this: http://www.mrexcel.com/tip012.shtml -----Original Message----- 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" wrote: 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. -----Original Message----- How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof . . . |
#7
|
|||
|
|||
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"... "GerryK" wrote: http://www.cpearson.com/excel/fractional.htm Chip has some info on DOLLARDE and DOLLARFR you may find useful for this. HTH -----Original Message----- Thanks GerryK, ill use the rounddown function. "GerryK" wrote: Not without VBA Try this: http://www.mrexcel.com/tip012.shtml -----Original Message----- 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" wrote: 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. -----Original Message----- How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof . . . |
#8
|
|||
|
|||
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)) -- Don Guillett SalesAid Software "Wayne hof" wrote in message ... How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof |
#9
|
|||
|
|||
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). "Don Guillett" wrote: 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)) -- Don Guillett SalesAid Software "Wayne hof" wrote in message ... How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof |
#10
|
|||
|
|||
I'm trying to calculate window and door measurements into square feet. Any
suggestions? Peggy "GerryK" wrote: Not without VBA Try this: http://www.mrexcel.com/tip012.shtml -----Original Message----- 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" wrote: 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. -----Original Message----- How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof . . |
#11
|
|||
|
|||
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) PeggyC wrote: I'm trying to calculate window and door measurements into square feet. Any suggestions? Peggy "GerryK" wrote: Not without VBA Try this: http://www.mrexcel.com/tip012.shtml -----Original Message----- 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" wrote: 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. -----Original Message----- How do you add or subtract feet & inches in formulas IE 12' 4" + 12' 8"... -- Wayne Hof . . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Measurement, in feet and inches, in Excel | Excel Discussion (Misc queries) | |||
Converting inches to feet & inches. | Excel Worksheet Functions | |||
Automatic Calculate Worksheets | Excel Worksheet Functions | |||
format numbers into feet / inches | Excel Worksheet Functions | |||
How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions |