If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is there a formula for inches to feet and inches?
I work with lengths, in inches (sometimes 50000 +inches), but need a quick way to convert them into feet and inches. Here is an example:
a1 144.625 b1 (suma1:a100) a2 143.875 b2 b1/12 ----------- this would give me 615.9832 feet : : a35 145.0 (I can be adding anywhere from 35 lengths to 325 lengths at a time) How do I get it to drop the whole feet, then multiply the "point feet" by 12 to get the inches again? -- Have you ever noticed the Roman Numerals for 40 is " XL". |
#3
|
|||
|
|||
Is there a formula for inches to feet and inches?
Try this =INT(ROUND(B1,0)/12)&" ft "&MOD(ROUND(B1,0),12)&" ins" -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=570954 |
Thread Tools | |
Display Modes | |
|
|