Hi,

I have our schedule for work in an excel file that I have recently made some updates to. It is now in a Gnatt-style chart to show employees starting and ending times as a stacked bar graph. What I would like to do now is show at the bottom of each chart how many people are simultaneously working each hour.
The schedule has a starting time and an ending time, along with duration in hours and in decimal format. The starting time and the decimal format of duration are the values that are used in the chart to make the lines for each shift.
As for the next step, I am lost as where to start, any suggestions?

Thanks,

Dan