Need to calculate time spent with each time in excel

Question

I have an issue where I want to calculate a particular issue's age with each team

table 1:

Issue no	Date	From Team	To Team
66	08-Nov	a	b
67	03-Apr	c	d
66	09-Nov	b	c
66	12-Sep	c	e
67	14-Oct	d	g
66	14-Sep	e	c
66	16-Sep	c	b
66	25-Sep	b	e

Now I have to calculate the below based on time spent in each team , need help in populating the below table

Table 2:

Issue no	Start Date	a	b	c	d	e	f
66	12-Sep
67	12-Sep

Start Date: Based on Issue No in Table 2, match issue table 1 and then it should print min of all the dates in table 1

E.g., For Issue no 66, min of all the dates is 12-Sep.. so the value 12-Sep should be printed in the column

Team a (Column c in the table 2) It should provide total time spent with that team b, for e.g., in team 'a' issue has come on 8-Nov and moved out on 9-nov, based on that it is 1 day issue 66 has spent with team a

similarly if team b total time spent will be total time issue has spent with team b.