Here's the situation, I have a large list of projects that I need to take the total estimated hours (Total Hours) and divide equally across the 4 quarters in 2014. I then need to ascertain the start date those hours will hit.
For example:
Project A Total Hours: 1500
2014 Quarter Start: 1st
Total Quarters (Project Duration): 4
I'd need a formula in quarter columns to solve for 1500/4 and begin with the first quarter.
Subsequent data will have projects starting in future quarters, for example:
Project B Total Hours: 200
2014 Quarter Start: 2
Total Quarters: 3
I'm at a loss. Been at this problem for 4 hours now and its starting to make my skin crawl! I've attached a reference example in format. Thanks for your anticipated assistance!2014projects_example.xlsx
Bookmarks