Closed Thread
Results 1 to 7 of 7

Convert Feet and Inches (Fractions) to Decimal Feet

  1. #1
    Registered User
    Join Date
    04-11-2016
    Location
    Boston, MA
    MS-Off Ver
    2010
    Posts
    3

    Convert Feet and Inches (Fractions) to Decimal Feet

    Hi,
    I picked up this formual in a previous thread. It converts Feet and inches to Decimal feet.

    =LEFT(B2,FIND("-",B2)-2)+SUBSTITUTE(REPLACE(B2,1,FIND("-",B2),""),CHAR(34),"")/12

    For example it converts 406'-11 1/8" to 406.9271.

    The problem is it gives me an error message "#value" if the number being converted is a negative number

    eg -373'-2 3/16" returns the "#value" .

    If I remove the minus sign i get the correct conversion 373.1823 but I don't want to have to keep removing the minus and then reinserting back in.

    Does anybody know how to change the formula that will convert the negative numbers

    Cheers

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Convert Feet and Inches (Fractions) to Decimal Feet

    Try wrapping the entire formula in a =ABS Function.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Convert Feet and Inches (Fractions) to Decimal Feet

    Try this...

    =LEFT(B2,FIND("'",B2)-1)+SUBSTITUTE(REPLACE(B2,1,FIND("'",B2)+1,""),CHAR(34),"")/12*IF(LEFT(B2)="-",-1,1)

  4. #4
    Registered User
    Join Date
    04-11-2016
    Location
    Boston, MA
    MS-Off Ver
    2010
    Posts
    3

    Re: Convert Feet and Inches (Fractions) to Decimal Feet

    Phuocam,
    Go Raibh Mile a Mhaith agat!!
    Thank you very much

  5. #5
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Convert Feet and Inches (Fractions) to Decimal Feet

    You're welcome!

  6. #6
    Registered User
    Join Date
    06-29-2022
    Location
    SC USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO
    Posts
    4

    Re: Convert Feet and Inches (Fractions) to Decimal Feet

    Trying to do something similar but it's laid out a little different and I can't seem to make it work...

    1'-1.15/16" as an example as 1 foot, 1 and 15/16 inches...and I want it in decimal. Help, and thanks in advance!

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Convert Feet and Inches (Fractions) to Decimal Feet

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert feet/inches to decimal
    By dingy101 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 03-23-2017, 12:40 PM
  2. Convert feet and inches to decimal feet
    By hrg in forum Excel General
    Replies: 12
    Last Post: 04-11-2016, 05:19 PM
  3. Convert Feet and inches to decimal feet
    By Laserdude in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-05-2014, 12:10 AM
  4. [SOLVED] Feet in decimal form to feet/inches
    By devpatel85 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2013, 10:18 AM
  5. Convert Decimal Feet to Feet and Inches
    By Surveyour in forum Excel General
    Replies: 6
    Last Post: 10-17-2013, 12:48 PM
  6. Convert feet and inches to deimal feet.
    By okenter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2011, 02:43 AM
  7. How do i convert feet and inches to a decimal value?
    By go_chrisg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2005, 12:06 PM

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