excel formula

[Shankar G]

1 case equel to 12 packets. In my system shows 215 case and 11 packet.
My hand i have 247 case and 9 packets. How i can make a excel formula
and result should show 31 case and 10 packets. in my excel sheets
shows 31.9899 shows. any one help me to slove.

 

[Gary''s Student]

With 31.9899 in A1, in B1 enter:
=INT(A1)
and in C1 enter:
=INT(12*(A1-B1))