+ Reply to Thread
Results 1 to 6 of 6

Need Help converting decimal to feet & inches 1/8 or to NFL style

  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    9

    Exclamation Need Help converting decimal to feet & inches 1/8 or to NFL style

    I am smart enough to know when to seek help from experts and this is one of those time. I have a twist to what would probably be a somewhat common in converting decimal inches to feet and inches or to NFL style.

    My situation is my results are in decimal for inches and 1/8s example is 73.2 (meaning 73 inches and 2/8). How can I convert 73.2 to equal 6' 1 2/8". OR to read how the NFL translates height 73.2 = 6012 (explanation is 6 foot 01 inches 2 eights)?

    Either or would make my day, both would make my week

    Thank you in advance

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need Help converting decimal to feet & inches 1/8 or to NFL style

    a
    b
    c
    1
    73.2
    6 1 2/8" b1: =int(dollarde(a1,8)/12) & text(mod(dollarde(a1,8),12)," 0 ?/8\""")
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-30-2013
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Need Help converting decimal to feet & inches 1/8 or to NFL style

    Thanks SHG so much for suggesting the conversion. I think we are close, The results I received were slightly off when using the above formula. Here are a few examples with the results that match (which i calculated in my head). Thanks again

    78.5 6' 6 5/8
    74.2 6' 2 2/8
    72.3 6' 0 3/8

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need Help converting decimal to feet & inches 1/8 or to NFL style

    >> The results I received were slightly off when using the above formula.

    Which ones?

    A
    B
    C
    1
    73.2
    6 1 2/8" B1: =INT(DOLLARDE(A1,8)/12) & TEXT(MOD(DOLLARDE(A1,8),12)," 0 0/8\""")
    2
    6012 B2: =LEFT(100*DOLLARFR(DOLLARDE(A1,8)/12, 12), 3) & RIGHT(A1*10)

  5. #5
    Registered User
    Join Date
    10-30-2013
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Need Help converting decimal to feet & inches 1/8 or to NFL style

    C1 came back slightly off. I am trying now to get C2 to work now

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need Help converting decimal to feet & inches 1/8 or to NFL style

    Do you have an example that's off?

  7. #7
    Registered User
    Join Date
    10-30-2013
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    9

    Wink Re: Need Help converting decimal to feet & inches 1/8 or to NFL style

    I Have no examples as it now WORKS AWESOME!!!!!!!

    Thank you so very much!

+ 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. [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 Decimal Feet to Feet and Inches
    By Surveyour in forum Excel General
    Replies: 6
    Last Post: 10-17-2013, 12:48 PM
  4. Conversions of Decimal Feet to Decimal Inches - Formula??
    By shubhamdev in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2012, 01:27 PM
  5. Conversions of Decimal Feet to Decimal Inches - Formula??
    By shubhamdev in forum Excel General
    Replies: 2
    Last Post: 04-15-2012, 03:57 AM

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