ebilbrough
Board Regular
- Joined
- Nov 17, 2010
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
I need to collect and sum manhours for an activity for a monthly period of time.
Cells A1 thru O1 contain 15 different start dates occurring during a single month for one activity.
The activity takes 4 consecutive days to complete and requires 7 manhours on day 1, 6 manhours on day 2, 4 manhours on day 3 and 4 manhours on day 4. Cells A2 thru D2 contain the manhours for the activity (7,6,4,4).
Cells AA1 thru AW1 contain the available work days (holidays & weekends removed) for the month.
Using the start date for each of the 15 activity occurrences and applying the manhours required to complete, I'm looking for a way to have the total hours calculated per work day for the month.
Cells A1 thru O1 contain 15 different start dates occurring during a single month for one activity.
The activity takes 4 consecutive days to complete and requires 7 manhours on day 1, 6 manhours on day 2, 4 manhours on day 3 and 4 manhours on day 4. Cells A2 thru D2 contain the manhours for the activity (7,6,4,4).
Cells AA1 thru AW1 contain the available work days (holidays & weekends removed) for the month.
Using the start date for each of the 15 activity occurrences and applying the manhours required to complete, I'm looking for a way to have the total hours calculated per work day for the month.
