Area Measurements

[Paul]

How can I calculate measurements? i.e. feet and inches.

 

[Jim]

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.

 

[Dave R.]

You can convert them, do calculations, then re-convert them.

 

[Jim]

How do you convert a value, such as 12' 9" into a decimal format, Paul?

 

[Dave R.]

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 #).

 

[Jim]

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.

 

[Dave R.]

Agree

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.

 

[gary b]

How can I calculate measurements? i.e. feet and inches.

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)

 

[Jim]

Very good! Works like a charm.