+ Reply to Thread
Results 1 to 9 of 9

formula to convert decimal feet to feet inch sixteenths

  1. #1
    tv
    Guest

    formula to convert decimal feet to feet inch sixteenths

    I would like to write a formula in excel, without using macros, to convert
    decimal feet to feet-inch-sixteenths.

    Can someone help me ?

  2. #2
    Bob Phillips
    Guest

    Re: formula to convert decimal feet to feet inch sixteenths

    Is this any good?

    =TEXT(INT(D18)," 0 ""feet """)&INT(MOD(D18,1)*12)&"
    "&TEXT(MOD(D18*12,1),"0/16")&" inches"

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "tv" <tv@discussions.microsoft.com> wrote in message
    news:519E2C11-5977-4479-A573-5C7470DBB769@microsoft.com...
    > I would like to write a formula in excel, without using macros, to convert
    > decimal feet to feet-inch-sixteenths.
    >
    > Can someone help me ?




  3. #3
    Doug Kanter
    Guest

    Re: formula to convert decimal feet to feet inch sixteenths


    "tv" <tv@discussions.microsoft.com> wrote in message
    news:519E2C11-5977-4479-A573-5C7470DBB769@microsoft.com...
    >I would like to write a formula in excel, without using macros, to convert
    > decimal feet to feet-inch-sixteenths.
    >
    > Can someone help me ?


    Are you able to write the formula on paper first?



  4. #4
    Toppers
    Guest

    RE: formula to convert decimal feet to feet inch sixteenths

    Decimal value in A1, formula in B1:


    =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16") & "in"

    A1=2.345 (ft)

    B1=2 ft 4 2/16 in

    HTH

    "tv" wrote:


    > I would like to write a formula in excel, without using macros, to convert
    > decimal feet to feet-inch-sixteenths.
    >
    > Can someone help me ?


  5. #5
    Bob Phillips
    Guest

    Re: formula to convert decimal feet to feet inch sixteenths

    Whilst I concede that yours is much better than mine, it can still be
    improved upon <vbg>

    =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16 ""in""")

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "Toppers" <Toppers@discussions.microsoft.com> wrote in message
    news:94F33E54-AB05-4FA2-BDA2-A95800A648C5@microsoft.com...
    > Decimal value in A1, formula in B1:
    >
    >
    > =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16") & "in"
    >
    > A1=2.345 (ft)
    >
    > B1=2 ft 4 2/16 in
    >
    > HTH
    >
    > "tv" wrote:
    >
    >
    > > I would like to write a formula in excel, without using macros, to

    convert
    > > decimal feet to feet-inch-sixteenths.
    > >
    > > Can someone help me ?




  6. #6
    Toppers
    Guest

    Re: formula to convert decimal feet to feet inch sixteenths

    Bob,
    I'm flattered!

    "Bob Phillips" wrote:

    > Whilst I concede that yours is much better than mine, it can still be
    > improved upon <vbg>
    >
    > =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16 ""in""")
    >
    > --
    > HTH
    >
    > Bob Phillips
    >
    > (remove nothere from email address if mailing direct)
    >
    > "Toppers" <Toppers@discussions.microsoft.com> wrote in message
    > news:94F33E54-AB05-4FA2-BDA2-A95800A648C5@microsoft.com...
    > > Decimal value in A1, formula in B1:
    > >
    > >
    > > =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16") & "in"
    > >
    > > A1=2.345 (ft)
    > >
    > > B1=2 ft 4 2/16 in
    > >
    > > HTH
    > >
    > > "tv" wrote:
    > >
    > >
    > > > I would like to write a formula in excel, without using macros, to

    > convert
    > > > decimal feet to feet-inch-sixteenths.
    > > >
    > > > Can someone help me ?

    >
    >
    >


  7. #7
    tv
    Guest

    RE: formula to convert decimal feet to feet inch sixteenths

    Thamk you for this formula
    however, i would like my result to read in the following format (ex: 4-6-8)

    can you help me tune the formula

    thanks

    "Toppers" wrote:

    > Decimal value in A1, formula in B1:
    >
    >
    > =INT(A1) & " ft " & TEXT(MOD(A1,1)*12, "# ??/16") & "in"
    >
    > A1=2.345 (ft)
    >
    > B1=2 ft 4 2/16 in
    >
    > HTH
    >
    > "tv" wrote:
    >
    >
    > > I would like to write a formula in excel, without using macros, to convert
    > > decimal feet to feet-inch-sixteenths.
    > >
    > > Can someone help me ?


  8. #8
    Ron Rosenfeld
    Guest

    Re: formula to convert decimal feet to feet inch sixteenths

    On Tue, 7 Mar 2006 13:27:26 -0800, tv <tv@discussions.microsoft.com> wrote:

    >Thamk you for this formula
    >however, i would like my result to read in the following format (ex: 4-6-8)
    >
    >can you help me tune the formula
    >
    >thanks


    Here's one way:

    =INT(A1)&"-"&INT(MOD(A1,1)*12)&"-"&ROUND(MOD(MOD(A1,1)*12,1)*16,0)


    --ron

  9. #9
    Registered User
    Join Date
    06-29-2011
    Location
    Minneapolis
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: formula to convert decimal feet to feet inch sixteenths

    =INT(MROUND(A1,1/16)/12) & "' " & TEXT(MOD(MROUND(A1,1/16),12),"#-#/##") & """"

    The formula above display inches with a decimal to feet and inches with a fraction to the nearest 16th; a great test for many formula's is to enter 23.999; above it will properly display 2' 0"

    The formula will display zero for feet and/or inches. e.g. 0' 0", or 2' 0", or 0' 1/16"

    other display examples would be like this: 1' 2-3/16"

    The MROUND function requires the Analysis Tool Pack addin to be installed; it's easy to research how if it's not installed.
    Last edited by theclockmaker; 10-10-2012 at 12:46 PM.

+ 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