Project Start Date and Tasks Start/Finish Time

Hi Everyone.

I am trying to solve task start and end dates and times based on the following criteria:
- Day Start Time: 09:00
- Day End Time: 17:00
- Break Duration: 1 hour
- Date of first task to be determined by a target completion date of all tasks. E.g. if all tasks should be completed by 16/12/2019 and there are 100 hours worth of work to do, what date would the first task need to start?
- Start time of first task should be 09:00.
- Tasks must only be done on weekdays.
- Start Date of preceding tasks should link to the end date of the predecessor AND if the predecessor task completes within 1 hour of the end of the working day, the next task should start at 09:00 the next day.



Sample data of what I would expect:

Calc. Planned Start Calc. Planned End Hours
08/11/2019 09:00 11/11/2019 16:00 14
12/11/2019 09:00 12/11/2019 17:00 7
13/11/2019 09:00 13/11/2019 15:00 5
13/11/2019 15:00 13/11/2019 17:00 2
14/11/2019 09:00 18/11/2019 10:00 15

Any help is most appreciated.

Hopefully file has attached. I thought I had to post 'x' number of posts before I was able to attach files, sorry.

Thanks JeteMc for your quick reply and effort to help me solve this problem.

One of our developers was able to help in the meantime and between us we were able to make it work.