Projected end dates subject to conditions

[jo3andr3w]

Hi,

I'm trying to prepare a study schedule/planner based on certain conditions:

Week starts on Monday
Study hours/day: 4 hours (Mon - Wed) & 12 hours (Thur - Sun)
Topics are assigned a time limit and will roll over to a new day until time limit expires.
In case a topic ends midway through a day, the remaining time of the day is allotted to the next topic.

Sample data would be:

Topic	Hours Allotted
ET	0
PW+BF	30
II	0
EA	0
AA	17.5
FI	75.5
EQ	43

<colgroup><col><col></colgroup><tbody>
</tbody>

As an example, for PW+BF, if started on a Monday (May 07, 2018), would end on Friday (May 11, 2018) with 6 hours of study time for Friday remaining which will be allotted to AA and so on.

I've tried a few things by myself (IF/IFS/Weekday) but can't figure out a way to incorporate the variable study times during the week. Any help would be appreciated!

Best,
Joe

 

[jo3andr3w]

Apologies if something similar has been asked before, would be grateful if I could be directed to that post/query.