Convert feet and inches to decimal feet.
--------------------------------------------------------------------------------
In column A1, I use for example: 6-11 (Text) and want to covert to decimal feet in column B1 (6.9166666666667).
Have been working on this for a week! With no luck.
6-11 is easy to type in a field and represents 6'-11"
Thanks
Last edited by okenter; 07-02-2011 at 10:41 PM.
Hi Okenter, welcome to the forum.
This should work for you:
=LEFT(A1,FIND("-",A1)-1)+MID(A1,FIND("-",A1)+1,2)/12
Hope that helps!
You might use
=LEFT(SUBSTITUTE(A1,"-",REPT(" ",5)), 4) + RIGHT(SUBSTITUTE(A1,"-",REPT(" ",5)), 4) / 12
there are 5 spaces in the new_text argument.
Last edited by mikerickson; 06-28-2011 at 02:45 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks