I have to determine the start date for production based on the ship date (ie: 4/10/18) minus production hours required. I know how to do the simple math, but I need to know the date based on 2 10 hour shifts and no weekend work. The caveat is I also want to include the start time.
Example ship date is 4/20 and there are 100 hours of work at 5 work stations. Normal math backs me up 4 days 4 hours. But really its 5 workdays + depending on if there is a weekend. I have tried WORKDAY but I can't get the result I want,
Any help would be appreciated.
Example ship date is 4/20 and there are 100 hours of work at 5 work stations. Normal math backs me up 4 days 4 hours. But really its 5 workdays + depending on if there is a weekend. I have tried WORKDAY but I can't get the result I want,
Any help would be appreciated.
