I feel like this is do-able but I can't think of how to do it. Production schedule. User enters a date and a start time - dates will be Mon-Friday only, and the start time must fall between 6am and 230pm (8 hours available each day). I need a formula, for the next stage of the process, knowing that each stage takes 19 hours to complete and can only be completed during working days/hours. For example - if I put today in and 130pm as my starting day/time, then my next stage, where I need the formula, should show Tuesday, Jan 17th, and a start time of 830am, because I had one hour today of work, 8 tomorrow, 8 more on Monday, and then 2 hours Tuesday morning. Hope that makes sense and someone can clear my brain fog - thank you in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
formula for next phase of work based on date & time
- Thread starter neov
- Start date
Similar threads
- Question
