Sum Billable Hours by Week by Team

[JustHooch]

I've been looking around but can't seem to find out how to sum billable Hours by week by teams.

Information that I have. All Dates are already calculated as workdays (Mon-Fri)

Each row has a different Task that is performed. Below is the layout of my information.

E2 = Team name
I2 = Total time by task
J2 = Number of days Allocated for the task (basically K2-J2 using workday)
K2 = Time per day (G2/H2)
L2 = Allocated Start Date
M2 = Allocated Stop Date

B1 = Project Start Date (Constant Value for all rows)
B2 = Project End date (Constant Value for all rows)

Some caveats:

• Start date if the Project can be any day Mon-Fri
• Allocated Start & stop date can span more than 1 week
• Team name can contain more than 1 team name

What I need to do is populate another table where

1. the weeks (Mon-Fri) are column headers P2 - U2 - calculated based on the project start & stop date
2. The total amount of time it tasks for each team to perform all the tasks in each of the given weeks

Sample spreadsheet attached

 

[JustHooch]

Ok so I can't figure out how to attach the file. Hopefully my explanation is enough.