I think I may have bit off more than I can chew. I said that I could do this and don't think I can now after playing with it for 3 days. I need to create a chart (assuming Gantt would be best) to auto shade a certain number of cells. We have complicated calculations to give the minutes needed to complete each part of a job. I need to take those minutes and convert them to a chart.
I think my first problem is that I need to show the estimated completion date for each part of the job (start and end time in minutes), allowing for lunch and an 8 hour workday. When I enter a formula using the workday function (=WORKDAY(A3,C3-1,$A$22:$A$27) It doesn't allow for the time of day or the lunch break. Many of the parts are multi-day - they will take at least 2 days. But there are some areas that may only take a few hours. Most of the jobs are over about a week's time. That's the first problem.
Then I need to create the chart with conditional formatting. Everything I am seeing is either VBA (which I've never done) or only within one day/week.
I have tons of data and can put it in a variety of places, so I don't think I need to give the cell references or layout at this point, because I think it may need to change.
PLEASE HELP!!
I think my first problem is that I need to show the estimated completion date for each part of the job (start and end time in minutes), allowing for lunch and an 8 hour workday. When I enter a formula using the workday function (=WORKDAY(A3,C3-1,$A$22:$A$27) It doesn't allow for the time of day or the lunch break. Many of the parts are multi-day - they will take at least 2 days. But there are some areas that may only take a few hours. Most of the jobs are over about a week's time. That's the first problem.
Then I need to create the chart with conditional formatting. Everything I am seeing is either VBA (which I've never done) or only within one day/week.
I have tons of data and can put it in a variety of places, so I don't think I need to give the cell references or layout at this point, because I think it may need to change.
PLEASE HELP!!
