+ Reply to Thread
Results 1 to 6 of 6

How to calculate Early, OnTime and Late Deliveries using an expected delivery window

  1. 07-03-2017, 11:22 AM #1
    MzDingle
    MzDingle is offline
    Registered User
    Join Date
    08-25-2015
    Location
    Dallas, Texas
    MS-Off Ver
    2010
    Posts
    14

    How to calculate Early, OnTime and Late Deliveries using an expected delivery window

    B = Expected Delivery Start
    C = Expected Delivery End
    E = Actual Delivery arrival

    - all times are military times
    - midnight is displayed as 00:00 instead of 24:00 ( so sometimes I get a negative time)
    - times do not include dates
    - any delivery time within the window is ONTIME
    - any delivery time before the start is EARLY TO WINDOW
    - any delivery time after the end is LATE TO WINDOW

    Expected Expected
    Expected Window Window Actual Actual
    DeliveryDate Start End Delivery Date Delivery Arrival
    05-29-2017 17:00 20:00 05-29-2017 18:36
    05-29-2017 19:00 22:00 05-29-2017 19:11
    05-29-2017 20:30 23:30 05-29-2017 21:31
    05-29-2017 21:45 00:45 05-30-2017 00:58
    05-29-2017 17:00 20:00 05-29-2017 17:03
    05-29-2017 17:45 20:45 05-29-2017 18:27
    05-29-2017 18:30 21:30 05-29-2017 19:45
    05-29-2017 19:30 22:30 05-29-2017 20:50
    05-29-2017 20:30 23:30 05-29-2017 21:50
    05-29-2017 21:00 00:00 05-29-2017 22:50
    Attached Files Attached Files
    Last edited by MzDingle; 07-03-2017 at 12:02 PM.
    Reply With QuoteRegister To Reply
  2. 07-03-2017, 11:51 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: How to calculate Early, OnTime and Late Deliveries using an expected delivery window

    Where should the formula go - column G? Which time are we working with - column E or F?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-03-2017, 12:01 PM #3
    MzDingle
    MzDingle is offline
    Registered User
    Join Date
    08-25-2015
    Location
    Dallas, Texas
    MS-Off Ver
    2010
    Posts
    14

    Re: How to calculate Early, OnTime and Late Deliveries using an expected delivery window

    B = Expected Delivery Start
    C = Expected Delivery End
    E = Actual Delivery arrival time

    Formula should go in column G.
    Reply With QuoteRegister To Reply
  4. 07-03-2017, 12:13 PM #4
    MzDingle
    MzDingle is offline
    Registered User
    Join Date
    08-25-2015
    Location
    Dallas, Texas
    MS-Off Ver
    2010
    Posts
    14

    Re: How to calculate Early, OnTime and Late Deliveries using an expected delivery window

    Also, if possible I need to (1) take into consideration the expected and actual delivery dates and when the times cross midnight. Row 22 is a good example.
    Reply With QuoteRegister To Reply
  5. 07-05-2017, 10:51 AM #5
    MzDingle
    MzDingle is offline
    Registered User
    Join Date
    08-25-2015
    Location
    Dallas, Texas
    MS-Off Ver
    2010
    Posts
    14

    Re: How to calculate Early, OnTime and Late Deliveries using an expected delivery window

    any updates?
    Reply With QuoteRegister To Reply
  6. 07-06-2017, 12:00 PM #6
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,562

    Re: How to calculate Early, OnTime and Late Deliveries using an expected delivery window

    See if the following yields the expected results:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. early/late deliveries
    By JeninQC in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-03-2017, 10:33 AM
  2. Count occurances where Deliveries were early or on time as compared to scheduled
    By GAVEL in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-18-2014, 11:05 AM
  3. [SOLVED] IF function: Early/On Time/Late Time vs. set window of time
    By hclark579 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2014, 05:37 PM
  4. Apointment Graph to Determine if there are weekly trends in late deliveries
    By mmanning in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-27-2013, 09:28 AM
  5. Easier way to Calculate # Days Early or Late Between Dates w/NETWORKDAYS formula
    By dburrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2013, 05:17 PM
  6. [SOLVED] formular that will calculate number of days late or early
    By SOUT in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-09-2012, 04:49 PM
  7. Early and Late Binding Vba Excel
    By VJ in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-07-2005, 02:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1