Hi
Input: (Plan Table)
In Plan table I have project wise and role wise planned working hours for next six months.
Output: (Actual Table)
In actual I am using multiple resources for one role, start date and end date is mentioned in actual table.
I want Plan table should divide the hours based on start date and end date for each role. (Like I have divided hours in actual table)
Please refer attached excel file.
Bookmarks