Equation for a summary table of hours worked

Hi!

I own a small business where we get work orders of work to do and we have to predict the hours that an employee will be working on a certain work order, based on three roles. The hours are spread up on 4 periods.

What I want to do is create an Hour summary chart to inicate how many hours per period an employee has worked (independant of the role since an employee can be assigned more than role) on a certain work order.

I have included an example of what I currently have, which doesnt work. I have some programming knowledge so I would be comfortable with these solutions as well.

In the example, the first table is to keep track of work orders, and who has what role. The second table is the report I would like to produce. As it stands, I use SUM (IF (role1), if(role2),if(role3)) to add all hours within a period, but to add a new work order, I have to add 4 lines, copy my equation to the 4th line added, and delete the first 3 so that the fields keep corresponding.

If this isnt clear, ask questions and I will answer as best as I can. Thank you!