+ Reply to Thread
Results 1 to 5 of 5

Conversions of Decimal Feet to Decimal Inches - Formula??

  1. #1
    Registered User
    Join Date
    04-15-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Conversions of Decimal Feet to Decimal Inches - Formula??

    Hello,
    I have to make a excel document in which I have length and width in feet and inch format.
    eg.
    10.01
    in which 10 is feet and .01 is inch

    I have all the length and width values in the above format.
    And what I want to do is convert the inch value (10.01) to feet value (.01=.08 feet)
    Just like the calculator here does.. http://daveosborne.com/dave/articles/decimalfeet.php

    Like
    10.01=10.08
    10.02=10.16
    10..03=10.25
    ...and so on...

    Here is table of conversions from inches to decimal feet. But I don't know how to get a formula for this in excel...????

    Inch Decimal of a Foot
    1 inch 0.0833
    2 inches 0.167
    3 inches 0.250
    4 inches 0.333
    5 inches 0.417
    6 inches 0.500
    7 inches 0.583
    8 inches 0.667
    9 inches 0.750
    10 inches 0.833
    11 inches 0.917
    12 inches 1.000



    Please help me..??!?

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Conversions of Decimal Feet to Decimal Inches - Formula??

    Good morning shubhamdev

    Something like this should work OK, if your original feet / inches is in cell A1 :
    =(VALUE(RIGHT(A1,LEN(A1)-FIND(".",A1,1)))/12)+ROUND(A1,0)

    Chip Pearson has an article here that deals with that very subject.

    HTH

    DominicB

  3. #3
    Registered User
    Join Date
    04-15-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Conversions of Decimal Feet to Decimal Inches - Formula??

    @dominicb

    Thanks for your support

    I almost got there.. but there are few things which I'm not getting accordingly..
    4-15-2012 1-39-37 PM.jpg


    Here is what I actually want..
    415201212037pm.jpg

    this is how I want my table to be...
    I will insert the values of length and width and formula should convert in into ft.
    2.11 into 2.91 (0.11 inch=0.91 feet)
    6.7 into 6.58 (0.7 inch=0.58 feet)
    And then I have to convert it into square feet.

    Please help..

  4. #4
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Conversions of Decimal Feet to Decimal Inches - Formula??

    So you are using 6.01 for 6 feet and one inch but six feet 2 inches is 6.2? It would be simpler if you used 6.01, 6.02, 6.03 etc.....but for your setup try this formula to convert

    =CHOOSE(MATCH(ROUND(MOD(A1,1),9),{0,0.1,0.11,0.2}),1,10,11,MOD(A1,1)*10)/12+INT(A1)
    Audere est facere

  5. #5
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Conversions of Decimal Feet to Decimal Inches - Formula??

    If you consitantly use two digits (6.02 rather than 6.2), then either
    =INT(A1)+(100*MOD(A1,1)/12)
    or
    =A1+(88/12)*MOD(A1,1) will do the conversion.

    Cross-Posted http://www.mrexcel.com/forum/showthread.php?t=628630
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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