Workweek Function

[benntw]

I have a gantt chart I built. G6 is my start date and time. F6 is my hourly duration. H6 is my finish date and time. What I am looking to do is have the choice if that row works 4, 5, 6, or 7 days a week. Is it possible to put how many days I'd like that line item to work in I6 and have the finish date and time follow that selection ?

 

[Rick Rothstein]

You want to calculate the finish date in cell H6, correct? I think we will need to know how many hours are worked in a single day.

 

[benntw]

Yes it would need to calculate the finish date and time. The hours are dynamic. I have my gantt setup as hours. Currently everything works perfect except it allows you to work 7 days a week. I was trying the WORKDAY.INT function and I could not get it to calculate the end date. I want to specify the workweek by the numbers to skip or work those days. The hours worked are your standard 24 hours

 

[Rick Rothstein]

I do not see how you can calculate a final date if you do not know two things... how many hours are worked per day (if you task takes 14 hours, someone working 4 hours per day will need twice as many days as someone working 8 hours per day) and which days are workdays (so you know what days a calculated time has to skip over). When you assume 7 working days per week, that last one becomes immaterial, but as soon as there are days off, you need to know which ones they are so you don't land on them with your calculated finish date.

 

[benntw]

I see what you are saying. Then with that said J6 I would put down the shift hours for that activity.

 

[Rick Rothstein]

And how will you designate either the working days or, alternatively, the days off?