Hi I would like to make a basic scheduling in excel. So here is what I want to do:
The Completion time simply= Start time + Process timeThe start time formula = The last process time.What I want to make is, how to make the completion time skip the non-working hours and days.
For example in the last row, I don't want to have the completion time or the start time of 23.50-0:33, because it is not the working hour anymore. So it should 8/4/2018 07:30 (start) --> 8/4/2018 08:13 (completion time)The determined working hour is: 07:30--23:30Moreover, about the working days, It is only calculated the workdays only, which is Monday-Friday.
------In addition, Actually I would like to determine the working day based on this calendar, so in this calendar I can determine which day is the working days (by determine which day is holiday and weekend)
For example in the last row, I don't want to have the completion time or the start time of 23.50-0:33, because it is not the working hour anymore. So it should 8/4/2018 07:30 (start) --> 8/4/2018 08:13 (completion time)The determined working hour is: 07:30--23:30Moreover, about the working days, It is only calculated the workdays only, which is Monday-Friday.
------In addition, Actually I would like to determine the working day based on this calendar, so in this calendar I can determine which day is the working days (by determine which day is holiday and weekend)
