View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?