Results 1 to 11 of 11

Timeline - Calculate end date/time with shift/lunch start and end

Threaded View

  1. #1
    Registered User
    Join Date
    06-15-2018
    Location
    Fremont, California
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    5

    Timeline - Calculate end date/time with shift/lunch start and end

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 04-25-2020, 03:23 AM
  2. [SOLVED] Calculate hours worked for a shift with lunch break
    By kobiashi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-10-2018, 05:13 AM
  3. Replies: 5
    Last Post: 07-29-2016, 03:15 AM
  4. [SOLVED] Calculate Start and End Time Stored as HH:MM when Shift extend past 00:00 (midnight)?
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2015, 12:38 PM
  5. Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  6. [SOLVED] Calculate number of hours from Start date and time and End date and time
    By sathyasun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2013, 01:04 AM
  7. Formula to calculate date and time stamps + lunch
    By excelgeezer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-02-2013, 05:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1