Feet and Inches formula

Question

Level 1

41 points

Feet and Inches formula

Is there an easy formula for converting cell values from Inches to non-decimal Feet & Inches? I can get feet and decimals, but '8.3333' isn't as intuitive for the applications I'm using the spreadsheet for!

All of 'em, Mac OS X (10.6.2)

Posted on Feb 25, 2010 1:56 AM

Reply

Answer 1

Badunit

Level 7

30,708 points

Feb 25, 2010 4:05 AM in response to katandmouse

If you start with a decimal number of inches in cell B2, you can convert it into feet and inches with the following formula:

=TRUNC(B2/12)&"ft "&MOD(B2,12)&"in"

Reply

Answer 2

katandmouse Author

Level 1

41 points

Mar 21, 2010 9:25 AM in response to Badunit

Perfect. Thank you very much.

Reply