Hi there, i'm new to this site!
Fairly good with excel but have hit a problem.
I have an ongoing production plan that works on a 17 hour day basis.
It uses standards to retrieve how many minutes the product will run for (in minutes)
So, if a product starts at 06:00 and the standards say the product will run for 5294 minutes (88 hours), I want the finish time and date to add the duration to give me the new time/date.
However, I say 17 hour day because we start work at 06:00am and finish at 23:00pm.. so that means it needs to know how many days to add to the date and also needs to avoid putting the finish time after 23:00 and before 06:00. (we can't finish an order if we re at home..)
I really hope someone can help me. If you're unsure of what im asking, then I can try to explain a bit better.
thanks
Bookmarks