Sum of hours based on weeknumber

Hi Guys,

I want here the sum of holiday hours based on employee name and weeknumber. Please check the difference between the holiday daes because some employees have between to dates more than one week holiday.
The holiday hours need also to be divided by number of workdays per week.

Start date holiday End Date holiday Employee Name Holiday Hours
19-05-2016 20-06-2016 Employee 1 80
17-05-2016 17-05-2016 Employee 2 0
17-05-2016 17-05-2016 Employee 3 0

See attachment for excel file

Regards,

=SUMIFS($D$2:$D$11411,$C$2:$C$11411,$G4,$A$2:$A$11411,">="&H$3,$B$2:$B$11411,"<"&I$3)
in row3 =7*H$2+(1&-H$1)-WEEKDAY(1&-H$1,2)+1
please check dates in your table