Area Measurements

  • Thread starter Thread starter Paul
  • Start date Start date
Look here, Michael:
http://myweb.cableone.net/twodays/
and download the "Convert feet..." file. It may be an.xla (addin); I do not
recall

If you download the xla, the two functions added are DFTOS and STODF
(Decimal Feet to Standard and Standard to Decimal Feet). It should be noted
the standard feet measurements (such as 12' 9") cannot be summed; xl sees
them as text; you have to sum as decimal, then convert.
 
Don't hold your breath waiting for Paul's response..

It is not hard to convert a text string like 12'9" into a decimal
representing inches ie (12*12)+9, or vice versa to change 62 inches into
5'2" using int and mod (and find, left, right, etc. in converting a text
string to a #).
 
No, it is not hard if you have the code or the addin I indicated. However,
if you were going to enter a the figure 12' 9" as 12.75, it would aleady be
converted.
 
Agree


Jim said:
No, it is not hard if you have the code or the addin I indicated. However,
if you were going to enter a the figure 12' 9" as 12.75, it would aleady be
converted.
Click to expand...
 
How can I calculate measurements? i.e. feet and inches.
Click to expand...

Vague questions beg vague answers...

For example: Cells A1, B1, and C1
A1 contains feet measure
B1 contains inches measure
C1 contains formula =A1+(A2/12)
C1 is decimal equivalent of A1/A2 combination
Columns CAN be summed; formula still applies
Reverse sequence/modify formula to reverse process

GL... (e-mail address removed)
 
Back
Top