How ? convert inches to feet-inches

[merlysys]

LO 6.3 calc

I enter in column W only
What formulas should go in columns X and Y?

[mikekaganski]

In X2:

=INT(CONVERT(W2;"in";"ft"))

In Y2:

=W2-CONVERT(X2;"ft";"in")

(without thinking about proper math here )

[anon73440385]

Feet (col X): =INT(W2/12)
Inch (col Y): =W2-X2*12

[EarnestAl]

For symmetry

Inch (col Y): =MOD(W2,12)

[ve3oat]

Better yet, see here :

CG62-CalcGuide.pdf