Measurement conversion in G-Sheets

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Measurement conversion in G-Sheets

  1. #1
    New Member Contech's Avatar
    Join Date
    Dec 2017
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Measurement conversion in G-Sheets

     
    I hope its ok to post questions about google sheets...

    I have the following problem:
    I need the following formula to convert into FEET" & INCHES" only.

    For example, my formula right has 13.8750(13' 7/8") converting to 166.5 INCHES. This conversion is correct but now what I need it for.

    I need it to convert to 156 7/8" (156.8750) i just don't know how to adjust it. So basically i need it to read the 13 as FEET and the .875 as INCHES to produce 156.8750 or 156 7/8".

    The formula i'm using now...
    =((A1-(mod(A1,1)))*12)+((A1-(A1-(mod(A1,1))))*12)&""""

  2. #2
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    19,185
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Measurement conversion in G-Sheets

    Google does have a forum for Google Sheets https://productforums.google.com/for...%7Cspell:false

    but if you are going to post it here, it should go in the General Excel Discussion and Other Questions forum.
    Last edited by Scott Huish; Dec 5th, 2017 at 07:22 PM.
    Office 2010/365

  3. #3
    New Member Contech's Avatar
    Join Date
    Dec 2017
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Measurement conversion in G-Sheets

      
    ok, thank you.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com