length formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I saw this once and didn't find out how they did it ... I need to set up 2 columns for length measurements between objects. Column 1 shows distance from a specific point (0'-0", 1'-10", 5'-3", 16'-7") and Column 2 shows the distance between points (n/a, 1'-10", 3'-5", 11'-4"). How can I format the column to opporate on a #'=feet - #"=inches format? so that I can A) add 6" to one cell, B) drag-fill to show a spacing of every 6", or B) set up a formula to calculate the difference between fields???

Any ideas?
 
Hi mchase,

Because of the format of the measurements x'-xx", makes
this much more difficult than need be. However, try this
formula to find the difference:

=INT(((LEFT(A1,FIND("'",A1)-1)*12+SUBSTITUTE(MID(A1,FIND("-
",A1)+1,255),"""",""))-(LEFT(B1,FIND("'",B1)-1)
*12+SUBSTITUTE(MID(B1,FIND("-",B1)+1,255),"""","")))/12)
&" ' "&"-"&MOD((LEFT(A1,FIND("'",A1)-1)*12+SUBSTITUTE(MID
(A1,FIND("-",A1)+1,255),"""",""))-(LEFT(B1,FIND("'",B1)-1)
*12+SUBSTITUTE(MID(B1,FIND("-",B1)+1,255),"""","")),12)
&" """

This will return the value in the same format - x'-xx"

Biff




-----Original Message-----
I saw this once and didn't find out how they did it ... I
Click to expand...
need to set up 2 columns for length measurements between
objects. Column 1 shows distance from a specific point
(0'-0", 1'-10", 5'-3", 16'-7") and Column 2 shows the
distance between points (n/a, 1'-10", 3'-5", 11'-4"). How
can I format the column to opporate on a #'=feet -
#"=inches format? so that I can A) add 6" to one cell, B)
drag-fill to show a spacing of every 6", or B) set up a
formula to calculate the difference between fields????
 
Back
Top