Hello,
I am trying to find a formula to convert inches to decimals of a foot. For example: 12' -6 1/2" would be equal to 12.5417. The only way I can convert right now is by using a paper conversion table to get the number. I have attached a copy of the Conversion table that I have been using so you can get a feel with what I am dealing with. I have also attached a screenshot showing what my spreadsheet looks like.
Thanks for your help!
=12 + round(6.5/12, 4)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This is not the answer to what you are asking however what about not converting, using columnB to input feet and columnC to input inches. Just letting the spread sheet figure it out as in:
Inches to Fractions of Feet.xlsx
Jerry,
Thanks for your reply. The formula you have is correct. I will be putting multiple lengths in column B, so would I need to have separate columns for the feet, inches and the fraction? Was hoping to get a formula that I could copy and paste into the spreadsheet. Thxs!
I don't know, maybe. Using real numbers is always easiest. I'd think FEET and INCHES only.
A1: 12
B1: 6.5
C1: =A1 + round(B1/12, 4)
Once it is working in one row, copy down for the others.
JeteMc,
It was so obvious yet so far away. I have not had enough coffee yet! Exactly what I was looking for.
Thanks for your help
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Your Welcome. In the event that the solution given is satisfactory an addition to reputation would be appreciated, also please mark the thread as solved. Hope you have a nice day. Come back whenever you have the need/inclination.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks