Calculate task end date based on working hours per shift

[placerda]

Hi.

I'm creating a Gantt chart for production planning and would like to calculate the end date of a task based on the number of working hours the task will need:

Entry:
Start date; Working hours needed

Note: Depending on the week day, the number of "available" hours will vary. For example, from monday to thursday it's 9hours and on friday it's 4hours.

Thank you in advance.

Regards,
Pedro Lacerda

 

[James006]

Hi,

It all depends on your level of complexity ... shifts, week-ends, holidays, lunch breaks ...

The True LEGEND is this field is Barry Houdini

Sum of work hours between two dates with changing shifts

Hello, I've tried how to calculate how many work hours were there between two dates when I have one work time during regular workdays and another work time during weekend (let's say Saturdays and Sundays have same work time for this example). So I want to calculate how many working hours...

www.mrexcel.com