Is there a formula for length?
 

I work a lot with measurements mostly in inches, but I have found a need to
convert them to feet and inches quickly, is there a macro or formula to do
this?
--
Peace to you,
Bill

Is there a formula for length?
 

You might check out the Convert() function in the Help files.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill" wrote in message
...
I work a lot with measurements mostly in inches, but I have found a need to
convert them to feet and inches quickly, is there a macro or formula to do
this?
--
Peace to you,
Bill

Is there a formula for length?
 

Hi!

There's nothing built in so you have to write your own formula. That formula
depends on the format you use. Post several examples and we'll see what we
can come up with.

Biff

"Bill" wrote in message
...
I work a lot with measurements mostly in inches, but I have found a need to
convert them to feet and inches quickly, is there a macro or formula to do
this?
--
Peace to you,
Bill

Is there a formula for length?
 

See Chip Pearson's site for working with feet and inches.

http://www.cpearson.com/excel/FeetInches.htm

Note the link on that page to Fractional Arithmetic.


Gord Dibben MS Excel MVP

On Tue, 18 Jul 2006 17:30:02 -0700, Bill wrote:

I work a lot with measurements mostly in inches, but I have found a need to
convert them to feet and inches quickly, is there a macro or formula to do
this?

Is there a formula for length?
 

Bill wrote:
I work a lot with measurements mostly in inches, but I have found a need to
convert them to feet and inches quickly, is there a macro or formula to do
this?


Bill, copy this function into a macro module:

Public Function ConvertFeet(ByVal Inches As Double) As String

Dim Feet As Double

Feet = Int(Inches / 12)
ConvertFeet = Str(Feet) & "'" & Str(Inches - Feet * 12) & """"

End Function

You can then address the function whenever you want within your
spreadsheet. e.g. If cell A1 contains the value 108 (inches) and you
type =convertfeet(A1) into cell A2 it will return the answer 9' 0"