View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default adding feet and inches

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

http://www.cpearson.com/excel/FractionalArithmetic.aspx


Gord Dibben MS Excel MVP

On Wed, 20 May 2009 11:50:01 -0700, Tacklemom
wrote:

I am trying to set up a spread sheet to calculate inventory. I need to add
some items in feet and some in inches. I need to know first do I set these
up at 2 columns one for feet and one for inches ( eg 5'-6" would be in two
seperate columns) and I also need to know how to add the feet and inches
together to know the total feet and inches that I have in stock..

Help please!