Is there a formula for inches to feet and inches?

08-11-2006, 07:20 PM

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

Pete_UK · 08-11-2006, 07:40 PM

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

[email protected] 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">
> <HTML><HEAD>
> <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>
> <DIV><FONT 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>
> <DIV><FONT face="MS Reference Sans Serif">a1 
> 144.625      b1 (suma1:a100)</FONT></DIV>
> <DIV><FONT face="MS Reference Sans Serif">a2 
> 143.875      b2
> b1/12               
> <----------- this would give me 615.9832 feet</FONT></DIV>
> <DIV><FONT face="MS Reference Sans Serif">:</FONT></DIV>
> <DIV><FONT face="MS Reference Sans Serif">:</FONT></DIV>
> <DIV><FONT face="MS Reference Sans Serif">a35 145.0</FONT></DIV>
> <DIV><FONT face="MS Reference Sans Serif"></FONT> </DIV>
> <DIV><FONT face="MS Reference Sans Serif"></FONT> </DIV>
> <DIV><FONT face="MS Reference Sans Serif">(I can be adding anywhere from 35
> lengths to 325 lengths at a time)</FONT></DIV>
> <DIV><FONT face="MS Reference Sans Serif"></FONT> </DIV>
> <DIV><FONT 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>
> <DIV><BR>-- <BR>Have you ever noticed the Roman Numerals for 40 is "
> XL".<BR></DIV></FONT></BODY></HTML>
>
> ------=_NextPart_000_010A_01C6BD7A.2D3E8690--

**daddylonglegs** · 08-11-2006, 07:45 PM

Try this

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

**Doodle Bug** · 07-20-2012, 11:17 AM

Have found this works as well as long a you dont need the answer to be used in an equation.

My cms were in cell a6, and this is the formula.
Cell A6 = 201cms

Formula - =INT((A6*0.393701)/12)&CHAR(39)&" "&TEXT(12*((A6*0.393701)-INT(A6*0.393701)),"# #/12")&CHAR(34)

End result - 6' 1 7/12"

**Doodle Bug** · 07-20-2012, 11:22 AM

Sorry just noticed that was for inches to ft and inces ok - easier one -

Cell A1 = 73.72 inches

Formula =INT(A1/12)&CHAR(39)&" "&TEXT(12*A1-INT(A1)),"# #/12")&CHAR(34)

End result 6' 8 8/12"