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

Thread: Measurement conversion in G-Sheets

  1. #1
    New Member
    Join Date
    Dec 2017
    Posts
    12
    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,598
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    3 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
    Join Date
    Dec 2017
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Measurement conversion in G-Sheets

    ok, thank you.

Some videos you may like

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
  •