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