Menu

Is there a formula for inches to feet and inches?

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

Default

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

Reply With Quote

Reply With Quote

#2

Report Post

Posted to microsoft.public.excel.worksheet.functions

Pete_UK

Pete_UK is offline

external usenet poster

Posts: 8,856

Default

Is there a formula for inches to feet and inches?

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"
<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-- <BRHave you ever noticed the Roman Numerals for 40 is "
XL".<BR</DIV</FONT</BODY</HTML

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

Reply With Quote

Reply With Quote

#3

Report Post

Posted to microsoft.public.excel.worksheet.functions

daddylonglegs daddylonglegs is offline

daddylonglegs is offline

external usenet poster

Posts: 1

Default

Is there a formula for inches to feet and inches?

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
feet and inches	steve	Excel Worksheet Functions	2	September 26th 05 05:34 PM
is there a macro that will convert from inches to feet and inches	cable guy	Excel Discussion (Misc queries)	1	June 20th 05 07:29 PM
Calculating the Area of objects in Feet and Inches	Sip8316	Excel Discussion (Misc queries)	7	May 23rd 05 09:19 PM
Converting inches to feet & inches.	svech61	Excel Worksheet Functions	2	November 27th 04 04:23 AM
How can I format a cell to accept feet and inches and add them	Jack	Excel Worksheet Functions	4	November 4th 04 12:30 AM

All times are GMT +1. The time now is 11:01 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement