Hi! I am working in excel 2003 and I need to convert feet and inches into decimal feet.
Example: 15'-10 5/8" to 15.88542
15'-10 5/8" will be in say, column B, and the conversion will be in say, column Q.
This formula will be copied all the way down the page.
Any thoughts on how to do this or can it even be done in this version?
Thanks for the help in advance.
hrg
Last edited by hrg; 02-17-2012 at 10:36 AM. Reason: Problem solved. Thanks a bunch!!!
Please post a sample workbook indicating ALL the variations you expect to see
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi
I have broken down the foot and then converted to decimal feet
Formate is important
See attached
REgards
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
=(left(a2,find("-",a2,1)-1)+0)+(mid(a2,find("-",a2,1)+1,find(" ",a2,1)-find("-",a2,1))/12)+(mid(a2,find(" ",a2,1)+1,1)/right(a2,1)/12)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Palmetto, I tried the formula but it didn't work. I got #value! for an error.
Any other ideas, anyone?
Thanks,
hrg
Another option is to use text-to-columns. If you set it to fixed width, you can add seperators where you want them, then put in a formula to just add the 2 numbers together
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
=(left(a2,find("-",a2,1)-2)+0)+(mid(a2,find("-",a2,1)+1,find(" ",a2,1)-find("-",a2,1))/12)+(mid(a2,find(" ",a2,1)+1,1)/mid(a2,find("/",a2,1)+1,len(a2)-(find("/",a2,1)+1)))/12
Try this,
Consider data starts from B2 to down.
In Q2,
=LEFT(B2,FIND("-",B2)-2)+SUBSTITUTE(REPLACE(B2,1,FIND("-",B2),""),CHAR(34),"")/12
then copy down.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Haseeb Avarakkan you are fantastic! Thank you very much. One thing that I noted was that if your measurement has a fraction in the inches with a number in front of the fraction you need to adjust the formula. EX: 51'-1/2" vs 51'-1 3 1/2". The first example will not calculate. Overall great time saving formula.
Thank you
Coco Boretto:
What is the edit to include the whole number in front of the fraction?
If you have a time, could you please explain how this formula works, or may you advise an article to study?Originally Posted by Haseeb A
Very nice, very helpful, thank you very much!
Haseeb A,
That formula worked great for me but is there any way it can be modified to accept negative numbers.
I have points from AutoCAD like -373'-2 1/16" which return an error "value"
Cheers
Welcome to the forum.
This is a very old thread and not many people will pick it up. Haseeb A's last activity was 08-02-2015 03:30 AM. So I guess he's no longer active on this forum.
And ... Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks