I have been trying to create a workbook that will generate a timeline for manufacturing when entering a start date and time, job quantity, and operation times. This timeline would take into account shift start and end times, lunch start and end times, as well as a holiday list. I ran into issues getting the End Date to properly take into account the shift times, and really ran into problems trying to include lunch breaks (I tried using networkdays, but ran into issues when an operation started after lunch one day, and ended prior to lunch on another day, or other combinations).
My brain is currently fried from trying to figure this out, so please let me know if anything needs to be clarified.
Regards,
Mike
Bookmarks