Good Evening,
Gonna need your help so badly, I am stuck with this case for quite long time.
So, basically, what I want to do is:
I want to know the completion time of one particular job, simply by adding the "start time" and "Process time", however, there is non-working hours that cannot execute the job:
a. Start day is 7:30 , end time is 23:30
b. 9:30-10:00 they need to have 1st break
c. lunch at 11:00 - 11:30
d. The second break is 13:30-14:00.
e. Dinner at 17:00-17:30
f. 1st break for second shift in 19.30-20:00
g. 2nd break for the second shift 21:30-22:00
g. Start day is 7:30 , end time is 23:30
For example, the first job started at 7:30, and takes 3 hours for the processing time, if there is no break time, then it will be finish at 10:30. However, as there is a break time between it, it will be finish at 11:00.
Using the same start time, but process time 3:30, then it will be finish at 12:00, instead of 11:30
I also attach the excel.
The first sheet is the scheduling area and the second sheet is the place I place the non-working hour.
nb: The next row of start time will be filled with the result of completion time of previous row.
THANKS !!!!
Bookmarks