Help with an Excel formula ... convert feet and inches into decimals
- Thread starter DarthTom
- Start date
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
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
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.
Google is your friend
http://www.google.de/#hl=de&safe=of...=f&aqi=&aql=&oq=&gs_rfai=&fp=1cd474ed5e5683a1
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!
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
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.
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
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.
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."
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.
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."
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.
And people wonder why the rest of the world prefers the metric system.
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.
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."
Thanks anyways man. I guess I could spend the $50 and call MS help.
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.
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.
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.
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!
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?
And people wonder why the rest of the world prefers the metric system.
Does anyone really wonder about that?
Similar threads
