Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel Feet & Inches

1 view
Skip to first unread message

Bill

unread,
May 16, 2003, 10:41:14 PM5/16/03
to
How can I display in a cell feet & inches. The way I need
to enter the data is like this: 5-6.5
That is 5 feet 6 1/2. I then need to either add or
subtract another set of feet & inches. Any ideas on what
I can do? Also how would I write the formula? Any help is
better then none.
Bill

Steve Sosensky

unread,
May 17, 2003, 2:48:46 AM5/17/03
to
Bill,

You'll need to format the cells where you enter the lengths as text, then parse
the cells to convert them into inches, do your arithmetic, then convert the
result back to feet and inches in text.

To parse the length, assume that the first length is in B2, the second is in C2,
the result is in D2, and e2 and f2 are the numeric inches.

In E2:

=value(left(B2,SEARCH("-",B2,1)-1)) * 12 +
value(right(B2,len(B2)-SEARCH("-",B2,1)))

In F2:

=VALUE(LEFT(C2,SEARCH("-",C2,1)-1)) * 12 +
VALUE(RIGHT(C2,LEN(C2)-SEARCH("-",C2,1)))

In D2:

=TEXT((e2-f2)/12,"0") & "-" & TEXT(mod(e2-f2,12),"0.00")

<html>
<font size=3>Steve &lt;<a href="mailto:st...@sosensky.com" eudora="autourl">mailto:st...@sosensky.com</a>&gt;<br><br>
Steve Sosensky, photographer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://www.sosensky.com/" eudora="autourl">www.sosensky.com</a><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SoCal Bird Guides&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://www.sosensky.com/guides/" eudora="autourl">www.sosensky.com/guides/</a> <br>
10834 Blix Street #213&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 818-508-4946<br>
Toluca Lake, CA 91602&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font><font size=2>&nbsp;&nbsp;&nbsp; 34.15645</font><font size=3> N, </font><font size=2>118.36715</font><font size=3> W<br>
Audubon in So. California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://www.socalaudubon.org/socal/" eudora="autourl">www.SoCalAudubon.org/socal/</a><br>
San Fernando Valley AS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://www.sanfernandovalleyaudubon.org/sfvas/" eudora="autourl">www.SanFernandoValleyAudubon.org/sfvas/</a><br>
AIM ID: SteveS310<x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</x-tab>&nbsp;&nbsp;&nbsp; Yahoo Messenger ID: SteveSosensky</font></html>

Dave Munday

unread,
May 17, 2003, 3:10:11 AM5/17/03
to
Bill,

Have a look at David McRitchie's MVP site. The following is a direct link
to his 'Carpentry' page which contains several examples of calculations
involving feet and inches.

http://www.mvps.org/dmcritchie/excel/formula.htm#Carpentry

Regards, Dave

"Bill" <lu...@willylumplump.com> wrote in message
news:051401c31c1d$c9054160$a401...@phx.gbl...

Jimmy L. Day

unread,
May 17, 2003, 10:56:31 AM5/17/03
to
Look here, Bill:
http://myweb.cableone.net/twodays/
and download the "Convert feet..." file. That may help you.


--
Greeting from the Mississippi Gulf Coast!
http://myweb.cableone.net/twodays


"Bill" <lu...@willylumplump.com> wrote in message
news:051401c31c1d$c9054160$a401...@phx.gbl...

0 new messages