Feet and fractional inches to decimal
Feet and fractional inches to decimal
(OP)
Can someone please show me the steps to adjust the formula in cell B1 to give me decimal inches based on cell A1? The formula in cell C1 works fine but it's referencing B1 which has a bogus result. Studying it I've learned that it doesn't want the dash or spaces between feet and inches but I'd like to have the dash there but no spaces. Any help would be greatly appreciated.
Thanks,
Doug
Thanks,
Doug





RE: Feet and fractional inches to decimal
=(LEFT(A1,FIND("'",A1)-1)*12)+(MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1)-FIND(" ",A1))+(MID(A1,FIND(" ",A1),LEN(A1)-FIND("/",A1)))/(MID(A1,FIND("/",A1)+1,LEN(A1)-FIND("/",A1)-1)))/12
RE: Feet and fractional inches to decimal
iv
RE: Feet and fractional inches to decimal
Here is a screenshot of the result. I still haven't figured out how it's giving me the fraction as a decimal. I'll have to study it some more.
iv, I found that formula on the net but it requires a different input format. I needed to keep my input the same as we've always done it.
Zelgar, I tried your formula but it gives me a value error. With Time I could probably figure it ot but for now I'm gonna go with what works(even tho I'm not quite sure why it works yet!)
Thanks again and if you happen to figure out where the decimal fraction is coming from feel free to let me know.
Doug
RE: Feet and fractional inches to decimal
RE: Feet and fractional inches to decimal
RE: Feet and fractional inches to decimal
Doug
RE: Feet and fractional inches to decimal
I haven't used Josh's add-in, so I really don't know if it is any good or not, only that the advertising seemed to indicate it addresses your problem. But assuming it does if you can keep everything straight when you change between the two machines, there is a simple fix. You could manually do it by using the edit links from the menu and edit the link to the incorrect path to the correct one. It's pretty easy, a half dozen mouse clicks or so. But if it were my spreadsheet, I'd write a little VBA procedure that does the same thing and does it automatically whenever the workbook is opened.
RE: Feet and fractional inches to decimal
Doug
RE: Feet and fractional inches to decimal
RE: Feet and fractional inches to decimal
Thanks for the replies,
Doug
RE: Feet and fractional inches to decimal
There are MANY websites that provide excellent info on VBA. Personally, I find ozgrid so valuable that I use it as my primary source of support information and search for answers there before anywhere else. For instance, if you want to know how to make a macro run automatically every time a workbook opens, google, "excel vba ozgrid run macro when workbook opens," and the first thing listed in google will be simple instructions on ozgrid.