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)
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.

Illustrated balance check. Document which row receives the difference.



