Add Multiple Columns based on same criteria found in multiple columns

I have a work schedule for each day of the week. Each day has three columns of information-1) the area and time working-COLUMN A 2) the total hours-COLUMN B 3) the employee assigned-COLUMN C.

An employee can be listed in multiple times on any given day and can be assigned different areas (rows) over the work week.

When preparing the schedule, I want to have a running total of hours I have assigned by employee to make sure that they are scheduled for the right amount of hours. Ideally, if I were able to have ALL the employees listed and as I modify the schedule their respective total hours would adjust accordingly.


Help Please!