convert column with inches to 2 columns "feet" and "inches"
 

I have a spreadsheet that has a column with total inches, but what I really
need is 2 columns that shows how many total feet there are in one column and
how many left over inches there are in the 2nd column. What formula can I use?

convert column with inches to 2 columns "feet" and "inches"
 

For feet: =int(a1/12)
For inches: =mod(a1,12)

Regards,
Fred

"fsudiane" wrote in message
...
I have a spreadsheet that has a column with total inches, but what I really
need is 2 columns that shows how many total feet there are in one column
and
how many left over inches there are in the 2nd column. What formula can I
use?

convert column with inches to 2 columns "feet" and "inches"
 

Feet Column: =rounddown(a2/12,0)
Inches Column: =mod(a2,12)

"fsudiane" wrote:

I have a spreadsheet that has a column with total inches, but what I really
need is 2 columns that shows how many total feet there are in one column and
how many left over inches there are in the 2nd column. What formula can I use?