- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help: Adding/Converting feet and inches
Posted on 1/21/16 at 9:49 am
Posted on 1/21/16 at 9:49 am
This is what I have...
Posted on 1/21/16 at 10:24 am to finchmeister08
Not looking at excel right now, but I'd keep them all as decimals, do c10*12, and sum those. It might have a fraction display like when you set something as $ or %, but idk
Posted on 1/21/16 at 11:44 am to Hammertime
quote:
It might have a fraction display like when you set something as $ or %, but idk
That's what I would look for, see if there's a number formatting that could help.
If not, maybe use hidden cells to convert the numbers to text using concatenate and "&".
Posted on 1/21/16 at 12:54 pm to finchmeister08
For anyone who is thinking about making fun of the OP for using the English system instead of the metric system I'll tell you right now that are two kinds of countries in the world:
Those that use the metric system
And
Those that have been to the moon
OP to answer your question, you will likely need to use a macro. Google it if you have the time.
Those that use the metric system
And
Those that have been to the moon
OP to answer your question, you will likely need to use a macro. Google it if you have the time.
This post was edited on 1/21/16 at 12:55 pm
Posted on 1/21/16 at 1:39 pm to finchmeister08
Just make a hidden locked cell to the side, and then have those output cells display whatever value is obtained from the hidden cell.
Posted on 1/21/16 at 1:49 pm to finchmeister08
For the
"A" Dimension, just make the number format fraction up to 2 digits.
17'6"1/2 doesn't even make sense to me.
Do you mean 17' 6 1/2" ???
"A" Dimension, just make the number format fraction up to 2 digits.
17'6"1/2 doesn't even make sense to me.
Do you mean 17' 6 1/2" ???
Posted on 1/21/16 at 3:18 pm to tiggerthetooth
yeah that's what I mean.
Posted on 1/21/16 at 6:00 pm to finchmeister08
You are going to have folks type in a foot, inch, and partial inch dimension and you want it to drive a formula (red cells are the inputs)?
I would make it similar and have:
Work Point Location
Feet [input] Inches [input]
Then, you can do the meat grinding in other rows where you convert those inputs into a single cell in inches. Hide that row once you have it linked to the appropriate formulas. This would make the entry much more simple, IMO.
This post was edited on 1/21/16 at 6:01 pm
Posted on 1/21/16 at 10:40 pm to lynxcat
It took some extra thinking but I ended up splitting the work point into 2 cells( one for feet and one for inches) and I did the same for the girt location. Now, if the inches ever exceed 12, I have it subtract 12 from the total and add 1 to the feet cell. Make sense?
Posted on 1/22/16 at 12:38 pm to finchmeister08
Posted on 1/22/16 at 3:40 pm to finchmeister08
quote:
It took some extra thinking but I ended up splitting the work point into 2 cells( one for feet and one for inches) and I did the same for the girt location. Now, if the inches ever exceed 12, I have it subtract 12 from the total and add 1 to the feet cell. Make sense?
Can you not make the inches a list that has rules that stop anyone from entering inches >12?
Posted on 1/23/16 at 9:55 am to finchmeister08
I have a couple of sheets at work that I'll look at next week. I'm pretty sure entering fractions is the most complicated way and every number has to be in separate individual cells. i.e. 17 is in a cell, 6 is in another, and 1/2 is another.
Posted on 1/23/16 at 6:40 pm to AutoYes_Clown
He should be able to figure out 6 1/2" = 6.5" and 6 1/4" = 6.25"
If he wants it in all one cell,
=(ft*12)+(in)
And just have whoever edit the formula each time
If he wants it in all one cell,
=(ft*12)+(in)
And just have whoever edit the formula each time
Posted on 1/23/16 at 10:01 pm to Lou Pai
quote:
For anyone who is thinking about making fun of the OP for using the English system instead of the metric system I'll tell you right now that are two kinds of countries in the world:
Those that use the metric system
And
Those that have been to the moon
I like to say the same thing but you have to let it come to you. Way to force it, funny guy.
Downvote.
Posted on 1/23/16 at 11:05 pm to Lou Pai
quote:
two kinds of countries in the world:
Those that use the metric system
And
Those that have been to the moon
There's a third that uses both, and they lose orbiters around Mars.
Posted on 1/24/16 at 7:33 am to finchmeister08
Convert everything metric to decimal metric meter. Convert metric meter to feet by multiplying by a cell with the conversion factor (3.33). Use $$ tool for that.
Posted on 1/26/16 at 1:24 pm to finchmeister08
After looking everything I have, I use decimal inch for my base unit of just about everything. I have a check display to show what decimal inch = in feet + inches rounded to 1/16th of inch so I can visually verify.
If "A1" is my decimal inch, then my formula to display is:
=INT(MROUND(A1,1/16)/12) & "ft " & TEXT(MOD(MROUND(A1,1/16),12),"#-#/##") & "in"
You can hack that formula up or use some sort of modified retrieve, but I recommend sticking to one cell as the base unit, and that being decimal inches.
If "A1" is my decimal inch, then my formula to display is:
=INT(MROUND(A1,1/16)/12) & "ft " & TEXT(MOD(MROUND(A1,1/16),12),"#-#/##") & "in"
You can hack that formula up or use some sort of modified retrieve, but I recommend sticking to one cell as the base unit, and that being decimal inches.
Popular
Back to top
Follow TigerDroppings for LSU Football News