I dunno where to stick this question so I'm putting it here. Does anyone have any idea how to write an excel formula that converts feet and inches into decimals in MS Excel? Thanks in advance for your help.
Re: Help with an Excel formula ... convert feet and inches into decima Google is your friend http://www.google.de/#hl=de&safe=of...=f&aqi=&aql=&oq=&gs_rfai=&fp=1cd474ed5e5683a1
Re: Help with an Excel formula ... convert feet and inches into decima Try this: http://www.cpearson.com/excel/FeetInches.htm
Re: Help with an Excel formula ... convert feet and inches into decima I appreciate it but for me that's as cryptic as a stereo manual. I was hoping that someone would help write it for me. So for example in column A I had 10' 10" it would convert that measurement in column B as a decimal.
Re: Help with an Excel formula ... convert feet and inches into decima I could kiss you man .. that works perfectly. Thank you so very much!
Re: Help with an Excel formula ... convert feet and inches into decima Say column A is number of feet, and B is number of inches. If you want decimal in columns C, try this: =A1+(B1/12)
Re: Help with an Excel formula ... convert feet and inches into decima I would have suggested that but I was going from the assumption he had a column formatted like this: 5'10" If it was two separate columns the solution is both obvious and simple.
Re: Help with an Excel formula ... convert feet and inches into decima And people wonder why the rest of the world prefers the metric system.
Re: Help with an Excel formula ... convert feet and inches into decima Spoke too soon Robert Maxwell ... formula doesn't work for just inches e.g. 2" - gives #value return and doesn't work for fractions e.g. 2 3/4" but thanks so much nonetheless for trying.
Re: Help with an Excel formula ... convert feet and inches into decima Here we see the value in having well-defined requirements. You said you've got "feet and inches," not "some that only have inches" and "some with fractional inches."
Re: Help with an Excel formula ... convert feet and inches into decima Thanks anyways man. I guess I could spend the $50 and call MS help.
Re: Help with an Excel formula ... convert feet and inches into decima I honestly do wonder that sometimes.
Re: Help with an Excel formula ... convert feet and inches into decima Or ask around the office and see if anyone knows Excel stuff really well.
Re: Help with an Excel formula ... convert feet and inches into decima Our on site IT person has no idea. LOL But good suggestion.
Re: Help with an Excel formula ... convert feet and inches into decima This is insanely complicated to do. But it can be done. This site has a way of doing it: http://www.lacher.com/examples/lacher18.htm - download the sample spreadsheet, which includes a visual basic module which you can copy into your own spreadsheet. I've tested it myself and it works, but as with anything like this, download and run only if you trust it enough.
Re: Help with an Excel formula ... convert feet and inches into decima I wasn't able to follow the instructions to copy. If I give you my personal e-mail address privately would you send the sample spread sheet to me please? I appreciate it.
Re: Help with an Excel formula ... convert feet and inches into decima The sample spreadsheet is at: http://www.lacher.com/files2000/lacher18.xls When you download it, enable the macros embedded in it when Excel prompts you to. Also, open up the spreadsheet you're working on. Then open up the Visual Basic Editor (ALT+F11 is the keyboard shortcut). Then open the Project Explorer (Ctrl-R). Expand the Modules section and drag Module 1 from the lacher spreadsheet into your spreadsheet. Now go into the spreadsheet you're working on. You'll find the function CInches now appears in the User Defined Functions (Formulas>Insert Function>User Defined>CInches). Use that function in your output cell, with the input data being the raw measurement (5'5", 1", 3' 3 1/2", whatever). The output cell will be the number in decimalised inches. You can convert to metres or whatever else you like easily from there. Hope that explains it OK; it's a bit tricky to do in text. Demonstrating would be easier, but impossible without my learning how to record a video of what I'm doing on screen! Don't thank me; thank Lacher or whoever first wrote that script!
Re: Help with an Excel formula ... convert feet and inches into decima Does anyone really wonder about that?