I wonder if anyone can help me, i need to work with some items in dozens, i have seen sheets such as mine that have been formulated to count and subtract in dozens but I have no idea how to do it for example 1.1 + 1.11 = 2 or 1.1 + 1.10 = 2.11

I would like the units on my sheet marked as dozens to perform the same as the units that count in gallons or singles.

I am very grateful to anyone who can help

Attached Files

Example stock.xls (72.5 KB, 15 views)