+ Reply to Thread
Results 1 to 2 of 2

Feet and Fractional Inches converted to DecFt

  1. #1
    Registered User
    Join Date
    12-04-2006
    Location
    St. Louis
    Posts
    17

    Feet and Fractional Inches converted to DecFt

    I have a values that show up as Feet and Fractional Inches (41'-10 1/4") and would like to convert it to a decimal value like 41.85
    Thanks,
    Greg

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Feet and Fractional Inches converted to DecFt

    Not sure exactly how you would like to approach it. If I were given text strings that looked exactly like that, I might:

    1) Text to columns or equivalent using "-" as the delimiter to separate ft and inches text string.
    2) Use find [(") and (')] and replace (null string) to remove these characters from the feet and inches text. Excel should recognize number (be careful if you have some fractional inches that are less than one. If they are showing up as something that Excel can interpret as a date, Excel will prefer the date interpretation over the fractional number interpretation).
    3) Add the two values together, converting inches to feet: =feet+CONVERT(inches,"in","ft").
    4) If Excel defaults to a # ?/? number format (carried over from the inches value), change number format to General or 0.00 or whatever you want.

    Would something like that work for you, or are there stipulations that I am not aware of?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert Feet and Inches (Fractions) to Decimal Feet
    By kellser in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-29-2022, 10:15 AM
  2. [SOLVED] Convert feet, inches, fractions to inches and decimals
    By bjohnsonac in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-03-2021, 12:08 PM
  3. [SOLVED] convert feet-inches-sixtennths to feet standard dimensions
    By Paul Morgan in forum Excel General
    Replies: 4
    Last Post: 10-29-2019, 03:28 PM
  4. [SOLVED] Convert inches to feet and inches (indirect function).
    By gannon_w in forum Excel General
    Replies: 7
    Last Post: 08-28-2019, 07:09 PM
  5. [SOLVED] Display Rounded Imperial Feet with Fractional Inches and Approximation Indicator
    By theclockmaker in forum Tips and Tutorials
    Replies: 0
    Last Post: 01-25-2019, 04:54 PM
  6. [SOLVED] Display Rounded Imperial Feet with Fractional Inches and Approximation Indicator
    By theclockmaker in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-25-2019, 04:54 PM
  7. [SOLVED] Convert decimal inches to fractional inches
    By Dowjd in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-08-2016, 04:48 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1