I have a sheet I’m using to calculate the number of tasks throughout the week. It is distributed based on hours worked each day. Mon-Thurs: 8.5 hours, Fri: 6 hours.

Right now I’m using a simple rounddown/up on the cells in the “Daily” row but as you can see below, they don’t always round properly so that the total at the end is the same as the actual amount I’m starting the day with.

How would I go about making sure they round properly so that the “Tasks:” each day equals the “Total” at the end of the row of days?

Any other improvements you all can think of to improve this would be appreciated. I feel like I’m getting better at this but 

​I have a sheet I’m using to calculate the number of tasks throughout the week. It is distributed based on hours worked each day. Mon-Thurs: 8.5 hours, Fri: 6 hours.Right now I’m using a simple rounddown/up on the cells in the “Daily” row but as you can see below, they don’t always round properly so that the total at the end is the same as the actual amount I’m starting the day with. How would I go about making sure they round properly so that the “Tasks:” each day equals the “Total” at the end of the row of days? Any other improvements you all can think of to improve this would be appreciated. I feel like I’m getting better at this but   Read More

​