RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 140,367
Posts: 5,446,456
Members: 24,970
Currently online: 570
Newest member: mineofilms

TrekToday headlines

November-December 2014 Trek Conventions And Appearances
By: T'Bonz on Oct 31

Kruge Bobble Head
By: T'Bonz on Oct 30

Two Trek Actors In Green Room
By: T'Bonz on Oct 30

Trek UglyDolls First Look
By: T'Bonz on Oct 29

New Star Trek Select Action Figure
By: T'Bonz on Oct 29

Trek Actors In Elsa & Fred
By: T'Bonz on Oct 29

The Red Shirt Diaries #9
By: T'Bonz on Oct 28

Greenwood Cast In Truth
By: T'Bonz on Oct 28

Cumberbatch In Talks For Strange
By: T'Bonz on Oct 28

Two New Trek Bobble Heads
By: T'Bonz on Oct 27


Welcome! The Trek BBS is the number one place to chat about Star Trek with like-minded fans. Please login to see our full range of forums as well as the ability to send and receive private messages, track your favourite topics and of course join in the discussions.

If you are a new visitor, join us for free. If you are an existing member please login below. Note: for members who joined under our old messageboard system, please login with your display name not your login name.


Go Back   The Trek BBS > Lounges & General Chat > Miscellaneous

Miscellaneous Discussion of non-Trek topics.

Reply
 
Thread Tools
Old September 30 2010, 07:51 PM   #1
DarthTom
Fleet Admiral
 
DarthTom's Avatar
 
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.
DarthTom is offline   Reply With Quote
Old September 30 2010, 07:56 PM   #2
FPAlpha
Vice Admiral
 
FPAlpha's Avatar
 
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
__________________
"But that emergency was supposed to be the fall of an Avenger!" Phil Coulson
"Exactly!"
Nick Fury
FPAlpha is offline   Reply With Quote
Old September 30 2010, 08:00 PM   #3
THE Robert Maxwell
Reports of my death...
 
THE Robert Maxwell's Avatar
 
Location: Robert Maxwell
View THE Robert Maxwell's Twitter Profile Send a message via ICQ to THE Robert Maxwell Send a message via AIM to THE Robert Maxwell Send a message via Windows Live Messenger to THE Robert Maxwell Send a message via Yahoo to THE Robert Maxwell
Re: Help with an Excel formula ... convert feet and inches into decima

Try this:

http://www.cpearson.com/excel/FeetInches.htm
__________________
Publishing all the news that's not fit to print, FROM BEYOND THE GRAVE!!!!
I has a blag.
THE Robert Maxwell is online now   Reply With Quote
Old September 30 2010, 08:01 PM   #4
DarthTom
Fleet Admiral
 
DarthTom's Avatar
 
Location: Atlanta, Georgia
Re: Help with an Excel formula ... convert feet and inches into decima

FPAlpha wrote: View Post
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.
DarthTom is offline   Reply With Quote
Old September 30 2010, 08:04 PM   #5
DarthTom
Fleet Admiral
 
DarthTom's Avatar
 
Location: Atlanta, Georgia
Re: Help with an Excel formula ... convert feet and inches into decima

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

Thank you so very much!
DarthTom is offline   Reply With Quote
Old September 30 2010, 09:35 PM   #6
SmoothieX
Vice Admiral
 
SmoothieX's Avatar
 
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)
SmoothieX is offline   Reply With Quote
Old September 30 2010, 09:46 PM   #7
THE Robert Maxwell
Reports of my death...
 
THE Robert Maxwell's Avatar
 
Location: Robert Maxwell
View THE Robert Maxwell's Twitter Profile Send a message via ICQ to THE Robert Maxwell Send a message via AIM to THE Robert Maxwell Send a message via Windows Live Messenger to THE Robert Maxwell Send a message via Yahoo to THE Robert Maxwell
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.
__________________
Publishing all the news that's not fit to print, FROM BEYOND THE GRAVE!!!!
I has a blag.
THE Robert Maxwell is online now   Reply With Quote
Old September 30 2010, 10:29 PM   #8
Canadave
Vice Admiral
 
Canadave's Avatar
 
Location: Saint Catharines, ON
View Canadave's Twitter Profile
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!
Canadave is offline   Reply With Quote
Old October 1 2010, 02:28 PM   #9
DarthTom
Fleet Admiral
 
DarthTom's Avatar
 
Location: Atlanta, Georgia
Re: Help with an Excel formula ... convert feet and inches into decima

Robert Maxwell wrote: View Post
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.
DarthTom is offline   Reply With Quote
Old October 1 2010, 03:19 PM   #10
THE Robert Maxwell
Reports of my death...
 
THE Robert Maxwell's Avatar
 
Location: Robert Maxwell
View THE Robert Maxwell's Twitter Profile Send a message via ICQ to THE Robert Maxwell Send a message via AIM to THE Robert Maxwell Send a message via Windows Live Messenger to THE Robert Maxwell Send a message via Yahoo to THE Robert Maxwell
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."
__________________
Publishing all the news that's not fit to print, FROM BEYOND THE GRAVE!!!!
I has a blag.
THE Robert Maxwell is online now   Reply With Quote
Old October 1 2010, 03:22 PM   #11
DarthTom
Fleet Admiral
 
DarthTom's Avatar
 
Location: Atlanta, Georgia
Re: Help with an Excel formula ... convert feet and inches into decima

Robert Maxwell wrote: View Post
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.
DarthTom is offline   Reply With Quote
Old October 1 2010, 03:26 PM   #12
SmoothieX
Vice Admiral
 
SmoothieX's Avatar
 
Location: Massachusetts
Re: Help with an Excel formula ... convert feet and inches into decima

Canadave wrote: View Post
And people wonder why the rest of the world prefers the metric system.
I honestly do wonder that sometimes.
SmoothieX is offline   Reply With Quote
Old October 1 2010, 03:50 PM   #13
THE Robert Maxwell
Reports of my death...
 
THE Robert Maxwell's Avatar
 
Location: Robert Maxwell
View THE Robert Maxwell's Twitter Profile Send a message via ICQ to THE Robert Maxwell Send a message via AIM to THE Robert Maxwell Send a message via Windows Live Messenger to THE Robert Maxwell Send a message via Yahoo to THE Robert Maxwell
Re: Help with an Excel formula ... convert feet and inches into decima

DarthTom wrote: View Post
Robert Maxwell wrote: View Post
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.
__________________
Publishing all the news that's not fit to print, FROM BEYOND THE GRAVE!!!!
I has a blag.
THE Robert Maxwell is online now   Reply With Quote
Old October 1 2010, 04:56 PM   #14
DarthTom
Fleet Admiral
 
DarthTom's Avatar
 
Location: Atlanta, Georgia
Re: Help with an Excel formula ... convert feet and inches into decima

Robert Maxwell wrote: View Post

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.
DarthTom is offline   Reply With Quote
Old October 1 2010, 05:05 PM   #15
Holdfast
Procul, O procul este profani!
 
Holdfast's Avatar
 
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.
Holdfast is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
FireFox 2+ or Internet Explorer 7+ highly recommended.