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".

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

wrote:
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".

------=_NextPart_000_010A_01C6BD7A.2D3E8690
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Google-AttachSize: 1633

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META http-equiv=Content-Type content="text/html; charset=iso-8859-1"
META content="MSHTML 6.00.2900.2912" name=GENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=#ffffff
DIVFONT face="MS Reference Sans Serif"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:/FONT/DIV
DIVFONT face="MS Reference Sans Serif"a1 
144.625      b1 (suma1:a100)/FONT/DIV
DIVFONT face="MS Reference Sans Serif"a2 
143.875      b2
b1/12                
<----------- this would give me 615.9832 feet/FONT/DIV
DIVFONT face="MS Reference Sans Serif":/FONT/DIV
DIVFONT face="MS Reference Sans Serif":/FONT/DIV
DIVFONT face="MS Reference Sans Serif"a35 145.0/FONT/DIV
DIVFONT face="MS Reference Sans Serif"/FONT /DIV
DIVFONT face="MS Reference Sans Serif"/FONT /DIV
DIVFONT face="MS Reference Sans Serif"(I can be adding anywhere from 35
lengths to 325 lengths at a time)/FONT/DIV
DIVFONT face="MS Reference Sans Serif"/FONT /DIV
DIVFONT face="MS Reference Sans Serif"How do I get it to drop the whole
feet, then multiply the "point feet" by 12 to get the inches again?/DIV
DIVBR-- BRHave you ever noticed the Roman Numerals for 40 is "
XL".BR/DIV/FONT/BODY/HTML

------=_NextPart_000_010A_01C6BD7A.2D3E8690--

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