inches to feet and inches

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frafi - 13 Apr 2004 03:42 GMT

I always receive lists of lengths in inches for steel fabrication and in
order to enter this info into my metal fabrication program I have to convert
it to feet and inches. For example 158 inches =
13 feet 2 inches. I can receive hundreds of these daily. Is there a way
enter the inches in excel
and receive feet and inches? Thanks for any help.

Reply to this Message

Anne Troy - 13 Apr 2004 04:01 GMT

Hi, frafi.
Check Lacher's info here:
http://lacher.com/examples/lacher18.htm

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com

> I always receive lists of lengths in inches for steel fabrication and in
> order to enter this info into my metal fabrication program I have to convert
> it to feet and inches. For example 158 inches =
> 13 feet 2 inches. I can receive hundreds of these daily. Is there a way
> enter the inches in excel
> and receive feet and inches? Thanks for any help.

Reply to this Message

RWN - 13 Apr 2004 04:02 GMT

One way;

Assume inches entered in A1
Resulting feet in A2 =Rounddown(A1/12,0)
Remaining inches in A3 =MOD(A1,12)

Signature

Regards;
Rob
------------------------------------------------------------------------

Reply to this Message

Frafi - 13 Apr 2004 04:18 GMT

Thanks so much. This is exactly what I wanted.

> One way;
>
[quoted text clipped - 11 lines]
> > enter the inches in excel
> > and receive feet and inches? Thanks for any help.

Reply to this Message

Dave Hawley - 13 Apr 2004 04:51 GMT

Hey Tuggy!

Great to see you are still sharing your knowledge.

Reply to this Message

Anne Troy - 13 Apr 2004 04:58 GMT

Hey, Davey... You bet!!
~Anne

> Hey Tuggy!
>
[quoted text clipped - 3 lines]
> Excel Templates, Training, Add-ins & Business Software Galore!
> Free Excel Forum http://www.ozgrid.com/forum ***

Reply to this Message

Bernard Liengme - 13 Apr 2004 13:37 GMT

Inches in A1 (say 38)
In B1 = A1/12 and give it custom format # ?/12 to see 3 2/12

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

Reply to this Message

Toby Erkson - 13 Apr 2004 16:51 GMT

Dude, that formatting idea is so cool!
Toby Erkson
Oregon, USA

>Inches in A1 (say 38)
>In B1 = A1/12 and give it custom format # ?/12 to see 3 2/12

Reply to this Message