Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 09, 07:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
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

  #2   Report Post  
Old May 20th 09, 09:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
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   Report Post  
Old May 20th 09, 10:46 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
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   Report Post  
Old May 21st 09, 10:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 08: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 06:24 AM


All times are GMT +1. The time now is 03:50 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017