The Trek BBS statistics

Posts: 5,805,281
Members: 26,073
Currently online: 495

 The Trek BBS Help with an Excel formula ... convert feet and inches into decimals

 Miscellaneous Discussion of non-Trek topics.

 September 30 2010, 07:51 PM #1 DarthTom Fleet Admiral     Location: Atlanta, Georgia Help with an Excel formula ... convert feet and inches into decimals 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.
 September 30 2010, 07:56 PM #2 FPAlpha Vice Admiral     Location: Mannheim, Germany Re: Help with an Excel formula ... convert feet and inches into decima Google is your friend http://www.google.de/#hl=de&safe=off...d474ed5e5683a1 __________________ "Chewie, we're home.."
 September 30 2010, 08:00 PM #3 Robert Maxwell Amphibious Admiral     Location: the bog Re: Help with an Excel formula ... convert feet and inches into decima Try this: http://www.cpearson.com/excel/FeetInches.htm __________________ You wish you could move like this. I has a blag.
September 30 2010, 08:01 PM   #4
DarthTom

Location: Atlanta, Georgia
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.

September 30 2010, 08:04 PM   #5
DarthTom

Location: Atlanta, Georgia
Re: Help with an Excel formula ... convert feet and inches into decima

 Robert Maxwell wrote:
I could kiss you man .. that works perfectly.

Thank you so very much!

 September 30 2010, 09:35 PM #6 SmoothieX Vice Admiral     Location: Massachusetts 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)
 September 30 2010, 09:46 PM #7 Robert Maxwell Amphibious Admiral     Location: the bog 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. __________________ You wish you could move like this. I has a blag.
 September 30 2010, 10:29 PM #8 Canadave Vice Admiral     Location: Saint Catharines, ON 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. __________________ My blog!
October 1 2010, 02:28 PM   #9
DarthTom

Location: Atlanta, Georgia
Re: Help with an Excel formula ... convert feet and inches into decima

 Robert Maxwell wrote: 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.
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.

 October 1 2010, 03:19 PM #10 Robert Maxwell Amphibious Admiral     Location: the bog 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." __________________ You wish you could move like this. I has a blag.
October 1 2010, 03:22 PM   #11
DarthTom

Location: Atlanta, Georgia
Re: Help with an Excel formula ... convert feet and inches into decima

 Robert Maxwell wrote: 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.

October 1 2010, 03:26 PM   #12
SmoothieX

Location: Massachusetts
Re: Help with an Excel formula ... convert feet and inches into decima

 Canadave wrote: And people wonder why the rest of the world prefers the metric system.
I honestly do wonder that sometimes.

October 1 2010, 03:50 PM   #13
Robert Maxwell

Location: the bog
Re: Help with an Excel formula ... convert feet and inches into decima

DarthTom wrote:
 Robert Maxwell wrote: 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.
__________________
You wish you could move like this.
I has a blag.

October 1 2010, 04:56 PM   #14
DarthTom

Location: Atlanta, Georgia
Re: Help with an Excel formula ... convert feet and inches into decima

 Robert Maxwell wrote: Or ask around the office and see if anyone knows Excel stuff really well.
Our on site IT person has no idea. LOL But good suggestion.

 October 1 2010, 05:05 PM #15 Holdfast Fleet Admiral     Location: 17 Cherry Tree Lane 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.

 Bookmarks