Resource Allocation and Scheduling using Excel

We have a list of tasks and their duration.
We need to distribute the tasks to different days, without exceeding the maximum available duration in a given day.
When the hours in a day are “used up”, we need to allocate the remaining task duration to the next day, and so on.
On the other hand, if a given task does not use up all of the hours in a given day, we will need to assign more than one task for that day, provided the combined duration do not exceed the available hours for that day.
In other words, we will need to split a task across one or more days, or combine one or more tasks into a single day, as needed, to maximize the work performed in a given day.