Breaking-up start & end DateTime based on Start and End times of other rows

[MichielRauws]

Hi there!

Unfortunately I have come across a problem I can not solve. Hopefully someone here can help me!

I have one dataset, which includes several tasks that are performed partially parallel.
I would like to get rid of parallel tasks, for which I feel like I need to first break-up all tasks so the end of one task is the start of another (without losing any data).

As an example, task A is from 01:00-02:00 and task B is from 01:30-02:30, I believe I first need to turn these two tasks into four tasks:

A: 01:00-01:30

A: 01:30-02:00

B: 01:30-02:00

B: 02:00-02:30

However, knowing what to do is one thing, I'm not succeeding at doing it.

Any suggestions on how to perform this explosion/break-up of tasks?

This is part of the data I'm using:

Task #	Start	End	Priority
1	00:00:00	01:00:00	1
2	00:45:00	01:30:00	3
3	02:00:00	02:30:00	2
4	01:00:00	03:30:00	4
5	03:00:00	04:00:00	2

Which I hope to turn into: 

Task #	Start	End	Priority
1	00:00:00	00:45:00	1
1	00:45:00	01:00:00	1
2	00:45:00	01:00:00	3
2	01:00:00	01:30:00	3
4	01:00:00	01:30:00	3
4	01:30:00	02:00:00	4
3	02:00:00	02:30:00	2
4	02:00:00	02:30:00	4
4	02:30:00	03:00:00	4
4	03:00:00	03:30:00	4
5	03:00:00	03:30:00	2
5	03:30:00	04:00:00	2

Below I've added a screenshot of how the broken-up tasks could look like. 

[ArtApa · Accepted solution]

Hi @MichielRauws - Here is a possible solution:

[MichielRauws]

Very clever! Thanks a lot!