Results 1 to 7 of 7

Scheduling in Excel (How to exclude non-working time in the calculation)

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2018
    Location
    China
    MS-Off Ver
    Office 365
    Posts
    18

    Scheduling in Excel (How to exclude non-working time in the calculation)

    Good Evening,

    Gonna need your help so badly, I am stuck with this case for quite long time.

    So, basically, what I want to do is:
    I want to know the completion time of one particular job, simply by adding the "start time" and "Process time", however, there is non-working hours that cannot execute the job:
    a. Start day is 7:30 , end time is 23:30
    b. 9:30-10:00 they need to have 1st break
    c. lunch at 11:00 - 11:30
    d. The second break is 13:30-14:00.
    e. Dinner at 17:00-17:30
    f. 1st break for second shift in 19.30-20:00
    g. 2nd break for the second shift 21:30-22:00
    g. Start day is 7:30 , end time is 23:30

    For example, the first job started at 7:30, and takes 3 hours for the processing time, if there is no break time, then it will be finish at 10:30. However, as there is a break time between it, it will be finish at 11:00.

    Using the same start time, but process time 3:30, then it will be finish at 12:00, instead of 11:30

    I also attach the excel.

    The first sheet is the scheduling area and the second sheet is the place I place the non-working hour.
    nb: The next row of start time will be filled with the result of completion time of previous row.



    THANKS !!!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 03-25-2022, 03:47 AM
  2. [SOLVED] time calculation formula not working well
    By Imran368 in forum Excel General
    Replies: 17
    Last Post: 08-07-2016, 01:45 AM
  3. [SOLVED] Time entry on UserForm displaying inccorectly and calculation not working on the time.
    By Colin Smit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-12-2014, 01:21 PM
  4. Scheduling: Calendar style scheduling based on scheduling list
    By denkatprieto in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-19-2012, 11:10 AM
  5. Exclude outliers in average calculation excel
    By mkvassh in forum Excel General
    Replies: 6
    Last Post: 10-15-2009, 08:36 AM
  6. Scheduling Time by Job per Week Excel 03
    By Havenstar in forum Excel General
    Replies: 0
    Last Post: 10-31-2005, 04:05 PM
  7. [SOLVED] Excel 2003, time scheduling?
    By Eric G in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 01:06 AM

Tags for this Thread

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