A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

adding feet and inches



 
 
Thread Tools Display Modes
  #1  
Old May 20th 09, 07:50 PM posted to microsoft.public.excel.misc
Tacklemom
external usenet poster
 
Posts: 17
Default adding feet and inches

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!
--
Donna
Ads
  #2  
Old May 20th 09, 09:18 PM posted to microsoft.public.excel.misc
Luke M
external usenet poster
 
Posts: 2,722
Default adding feet and inches

Correct, you either need to input as two columns(A & B?), or use decimals
(i.e., 5'6" inputed as 5.5

Former solution formula, result in inches:
=SUM(A1:A100)*12+SUM(B1:B100)
Result in ft:
=SUM(A1:A100)+SUM(B1:B100)/12

If you use decimals, its a straightforward sum.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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!
> --
> Donna

  #3  
Old May 20th 09, 10:46 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 22,911
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!


  #4  
Old May 21st 09, 10:24 PM posted to microsoft.public.excel.misc
Martin Fishlock
external usenet poster
 
Posts: 694
Default adding feet and inches

Another way is to format the cells as fractions and us 5 6/12.

--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"Luke M" wrote:

> Correct, you either need to input as two columns(A & B?), or use decimals
> (i.e., 5'6" inputed as 5.5
>
> Former solution formula, result in inches:
> =SUM(A1:A100)*12+SUM(B1:B100)
> Result in ft:
> =SUM(A1:A100)+SUM(B1:B100)/12
>
> If you use decimals, its a straightforward sum.
>
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "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!
> > --
> > Donna

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
change feet and inches to decimal inches Brian 1 Excel Worksheet Functions 4 May 2nd 09 04:02 AM
Convert inches & display as Feet Inches and Fractions -- BUG FREE Mark Main Excel Worksheet Functions 12 November 26th 08 09:50 PM
Converting from feet, inches and fractions to inches and decimal p Dee Setting up and Configuration of Excel 5 September 18th 07 04:18 PM
is there a macro that will convert from inches to feet and inches cable guy Excel Discussion (Misc queries) 1 June 20th 05 07:29 PM
Need formulas for adding feet, inches & fraction in one cell Wayne hof Excel Worksheet Functions 1 January 7th 05 07:24 AM


All times are GMT +1. The time now is 08:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.