+ Reply to Thread
Results 1 to 6 of 6

Converting Ft/Tenths to Ft/Inches in Decimal form

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    TX, USA
    MS-Off Ver
    2010
    Posts
    2

    Converting Ft/Tenths to Ft/Inches in Decimal form

    I am currently needing help converting feet.tenths to feet.inches

    I understand the conversion, just not sure how to seperate the number into two parts, since its only the decimal that needs to be multiplied 12, also, if it has to be broken down, a formula to put the number back together in the a cell would be nice.

    ie: 3.8, 2.3, 4.8

    Thanks, Nic

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Converting Ft/Tenths to Ft/Inches in Decimal form

    Hi, and welcome to the forum.

    perhaps either
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Converting Ft/Tenths to Ft/Inches in Decimal form

    This would do but stores the result as text
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    ________________________________________________________
    If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.

    Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.

  4. #4
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Converting Ft/Tenths to Ft/Inches in Decimal form

    Try exploiting the DOLLARFR() function.
    With
    A1: 3.8 <-meaning 3 feet and 8 tenths inches.

    This formula converts that value from feet.tenths to feet.twelfths
    Please Login or Register  to view this content.
    In that example, the formula returns: 3.096
    read as 3 feet and 9.6 twelfths

    8 tenths = 9.6 twelfths

    However, if
    3.8 literally means 3.8 feet then try this
    Please Login or Register  to view this content.
    which returns: 3.96

    Is that something you can work with?
    Last edited by Ron Coderre; 07-09-2014 at 11:33 AM.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  5. #5
    Registered User
    Join Date
    07-09-2014
    Location
    TX, USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Converting Ft/Tenths to Ft/Inches in Decimal form

    While I was awaiting an answer, I tried a few of my own plug-ins.

    Using Column F*

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    & yes, it was literally feet.

    I ran both formulas side by side, & all seems to work.

    Thank You for your help Ron.

  6. #6
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Converting Ft/Tenths to Ft/Inches in Decimal form

    Glad you got something you can use!

    If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)
    ...BTW: If anybody was particularly helpful, you can thank them by clicking the "Add Reputation" star under one of their posts.

+ 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] Feet in decimal form to feet/inches
    By devpatel85 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2013, 10:18 AM
  2. Need Help converting decimal to feet & inches 1/8 or to NFL style
    By athres in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-30-2013, 11:39 AM
  3. Converting time into tenths of an hour (with a twist).
    By Comebakatz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2013, 10:26 AM
  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

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