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

[fsudiane]

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?

 

[Fred Smith]

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

Regards,
Fred

 

[Benliaw]

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