Summing items in multiple columns

Hi all,

I am trying to make my own scheduling spreadsheet for a business that I manage and I want to make it easier on myself. Usually I would just calculate by hand how many hours I would give each employee, but I figure I can let Excel do that for me. I will attach a sample document of what I am trying to accomplish.

I want the formula to find the specified employees name, see what shift they are working, and then sum up the corresponding hours associated to that shift. I figured out how to do this for one specific day, but I want it to sum up the employee's hours of the entire week. In my sample I am just working with two days, but I cant figure it out. I would prefer to not change the layout of the schedule either.

Please help!

Attachment 387990