I have been slowly self-teaching through google and Youtube tutorials based on my needs at the time but I'm at best a mid level Excel user. But Excel's organizational capabilities for task management and budgeting has just been *chefs kiss* so I would love to get a little better at it.
In terms of the task management, I've attached what I've created so far.
The basics are:
I have a set number of tasks that changes at the start of each week.
Mon-Thurs is a 8.5 hour day
Fri is a 6 hour day.
Currently using ROUNDUP and DOWN for the Daily Row to calc what I would need to do each day. However as you can see by Tuesday, that doesn't always result in the Total Column adding up to the Tasks amount.
Is there a way to make it so that the number of tasks... I guess divvy's up the amount across those days according to the percentage of the hours for that day without going over the amount?
Sorry if confusing or too basic for this forum. I'm new to the board etc.
In terms of the task management, I've attached what I've created so far.
The basics are:
I have a set number of tasks that changes at the start of each week.
Mon-Thurs is a 8.5 hour day
Fri is a 6 hour day.
Currently using ROUNDUP and DOWN for the Daily Row to calc what I would need to do each day. However as you can see by Tuesday, that doesn't always result in the Total Column adding up to the Tasks amount.
Is there a way to make it so that the number of tasks... I guess divvy's up the amount across those days according to the percentage of the hours for that day without going over the amount?
Sorry if confusing or too basic for this forum. I'm new to the board etc.
