Hello,
I have created a stacked bar chart to depict the amount of time it takes each of my technicians to complete a project. The issue I am running into is when I assign my technicians a task that takes several days or even weeks. If I am planning on assigning this task to someone and assuming it should take them 40 hours to complete it, I don't want that 40 hours to be completed in the first two days. I want the chart to recognize an 8 hour working day as well as weekends. The only time I would like the chart to recognize the weekends or hours not between 8AM-5PM, would be for overtime. Does anyone know how to accomplish this? Is there a way to assign each day a value of 8 hours or something? Any help would be appreciated.
Thank you in advance for any assistance.
-eforti
I have created a stacked bar chart to depict the amount of time it takes each of my technicians to complete a project. The issue I am running into is when I assign my technicians a task that takes several days or even weeks. If I am planning on assigning this task to someone and assuming it should take them 40 hours to complete it, I don't want that 40 hours to be completed in the first two days. I want the chart to recognize an 8 hour working day as well as weekends. The only time I would like the chart to recognize the weekends or hours not between 8AM-5PM, would be for overtime. Does anyone know how to accomplish this? Is there a way to assign each day a value of 8 hours or something? Any help would be appreciated.
Thank you in advance for any assistance.
-eforti