inches to feet and inches

F

Frafi

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

RWN

One way;

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

Frafi

Thanks so much. This is exactly what I wanted.
RWN said:
One way;

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

Bernard Liengme

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top