Allocating OT Hours - SOLVED

I need to allocate OT hours back to campaigns the employee worked.
I've searched the forums and not found a solution that I believe will work.
I am able to determine OT hours by week by employeee using a pivot table and am also able to determine total hours per employee by week by employee but need a way to easily combine the data.
I've attached a sample ane would appreciate any potential solutions.
I am a frequent user of pivot tables and have some experience with VBA so I am open to various type solutions. I am not locked into any one solution.