You have 10.00 hours to split among three activities. Rounding every share to 3.33 leaves a hundredth of an hour unallocated. Give that remainder to one agreed row.

Round the first two rows and calculate the third

Put 10 in B1. In B2 and B3, enter =ROUND($B$1/3,2). Both display 3.33. Enter the following in B4:

=ROUND($B$1-SUM(B2:B3),2)

Three rounded 3.33-hour shares add to 9.99 hours.

Illustrated shortfall. The original total is ten decimal hours.

Check the sum at the intended precision

B4 should show 3.34. Use =SUM(B2:B4) and show two decimal places. The result is 10.00 hours. Add a note that the last activity receives the remainder. If your allocation rules put that difference elsewhere, change the balancing row and verify the total again.

The final share becomes 3.34 so all rows add to 10.00 hours.

Illustrated balance check. Document which row receives the difference.

Microsoft’s ROUND function reference