I have a table which tracks information for a number of projects, each project is it's own record. Two of the dates I track are a start and finish date. I also have a number of hours quoted to work on the project in total.
My goal is to build a chart that shows each month with active projects with a sum total of hours quoted per month for all projects. It's unlikely that hours will actually be divided up exactly evenly by month, but as far as resource planing goes it should be close enough.
For example, if I have one project that is scheduled to go from May-August and take 100 hours, each month would be allocated 25 hours. If I had second project from July-August and take 50 hours, each month would be allocated 25 hours again. The ending result would be a bar graph showing May (25 hours) June (25 hours) July (50 hours) and August (50 hours).
Any ideas on how to complete this, if it's even possible?