In excel I have a labor report that lists out labor. This report's important columns are: project number, labor type, date, and quantity. I want to summarize this data based on another report I have. This other report has the same project numbers but states different milestone dates. I want to have access take my labor hours and based on the milestone date summarize the hours before this milestone and after the milestone, by each project.
So for example one project has 100 different labor entries each with a date. I want to summarize this labor by project, then based on if it is after a certain milestone date or before. Once I have totaled the amount of labor before and after this milestone date I want to have another field that calculates the labor distribution. So it would say: before%=beforehours/totalhours. And the same thing for the after distribution.
I think I confused myself typing this out. Hope you guys can decipher this.