Is there a formula for inches to feet and inches?

[Guest]

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?

 

[Pete_UK]

This will give you the whole number of feet:

=INT(B2)

so you could subtract that from B2 to give you the fractional part,
i.e.:

=B2 - INT(B2)

Alternatively, you could use this formula to give you the fractional
part directly:

=MOD(B2,1)

Obviously, in either case you then multiply by 12 to get the number of
inches, so you would have:

=(B2-INT(B2))*12 or:

=MOD(B2,1)*12

Hope this helps.

Pete

 

[daddylonglegs]

Try this

=INT(ROUND(B1,0)/12)&" ft "&MOD(ROUND(B1,0),12)&" ins