I have a spreadsheet that shows employee name, shift start time, am break start time, am break end time, lunch start time, lunch end time, pm break start time, pm break end time, and shift end time.
Example:
Tammy 8:00 9:30 9:45 12:30 13:30 15:00 15:00 17:00
I want to chart this so that it looks like a floating or Gantt chart. I know I could manually "color" in the blocks but I was hoping there was a way to have excel create the chart in case schedules change. After I get the hours charted I want to show a trendline that shows call volume by time ....
this is so a customer service helpdesk can evaluate that they have enough people on the phones during peak call time.
Does anyone have any ideas? I have read a lot of articles about Gantt charts and floating charts here and on other boards but they all are project based and deal with dates - not times. My shifts are 24 hour days too so I have folks in at midnight etc.
Thanks in advance!
Example:
Tammy 8:00 9:30 9:45 12:30 13:30 15:00 15:00 17:00
I want to chart this so that it looks like a floating or Gantt chart. I know I could manually "color" in the blocks but I was hoping there was a way to have excel create the chart in case schedules change. After I get the hours charted I want to show a trendline that shows call volume by time ....
this is so a customer service helpdesk can evaluate that they have enough people on the phones during peak call time.
Does anyone have any ideas? I have read a lot of articles about Gantt charts and floating charts here and on other boards but they all are project based and deal with dates - not times. My shifts are 24 hour days too so I have folks in at midnight etc.
Thanks in advance!