Find solution
How do you convert pixels to inches?

Formula to convert decimal feet to feet and inches, not for EXCEL, for a plumbing exam. My husband needs help!?

  • My husband has a test at school today and he has lost his study book at his job site. We have looked online but we can only find formulas for Excel. So we he needs to know the formula to convert decimal feet to feet and inches, also needs the formula to convert feet and inches into decimal feet? Please help if you know. He had decimal feet divided by 100 for the first one and multiply ft. by 100. These formulas are not correct! Thanks for any help you can give.

  • Answer:

    To convert decimal feet to inches, or vice versa think in terms of equivalent fractions, depending on the number of decimal places used ... The rule is to convert to an improper fraction first, then divide by the original denominator. Multiply by new denominator for the answer ... For example, for decimal to inches ... 4.6 ft = 4 6/10 ft 4 6/10 = 4 x 10 + 6 = 40 + 6 = 46 46 divided by 12 = 3 + 10/12 or 3'10" In reverse, for inches to decimal ... 3'10" = 3 + 10/12 = 36 + 10 = 46 46 divided by 10 = 4.6 *** If the answers were to two decimal places, the division or multiplication would be by 100, not 10 ...

Jana C at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

for inches into decimal take the inches portion and divide by by 12 (1 ft = 12 inches) for decimal into inches multiply the decimal by 12 to get inches

Eclipse-girl

Use the CONVERT function. Say you have 2.5 in one cell (which you know is 2 feet 6 inches) Use this where you want your result: =VALUE(LEFT(A2,FIND(".",A2,1)-1))&" feet "&(CONVERT(MOD(A2,1),"ft","in")&" inches") As for converting the other way. If you put feet in one cell, and inches in another, use this: =A2&TEXT(CONVERT(B2,"in","ft"), ".#")&" feet" where A2 is Feet and B2 is inches. The reason for the TEXT function is to make Excel format is so you won't see 20.5 (for 2 feet, 6 inche) since 2 and 0.5 would be the result otherwise. TEXT forces the format so it appears as 2.5. If you want more than 1 decimal place, add more #'s to the formula.

Greg G

If your husband is not good in bed then let me know. I'll be there to help ya ;p

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.