Results 1 to 7 of 7

Convert Decimal Feet to Feet and Inches

Threaded View

  1. #1
    Registered User
    Join Date
    05-16-2011
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    2

    Convert Decimal Feet to Feet and Inches

    Hello, I am currently working on cut sheets for my current project. I need to take my decimal feet (ie 1.55) and display them as feet and inches (1' 6 5/8") not (1' 6 3/5") i have a formula which is this=INT(F17)&"' "&TEXT(12*(F17-INT(F17)),"# #/#")&CHAR(34), It works but the problem is the fractional inches 6 3/5" i need them to display in 1/8 1/4 1/2 when applicable. Is there something i could add to this formula to make my inches read like a measuring tape (1' 6 5/8") 1/8 1/4 1/2??? I attached the spreedsheet for review thanks!
    Attached Files Attached Files

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