Is there a formula for inches to feet and inches?

G

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?
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top