+ Reply to Thread
Results 1 to 2 of 2

Truck Queue/Wait Time

  1. #1
    Registered User
    Join Date
    01-09-2023
    Location
    United States
    MS-Off Ver
    Microsoft Excel
    Posts
    1

    Truck Queue/Wait Time

    Hello all!
    I'm trying to figure out a logic/formula in excel to calculate the hold time of a trailer waiting in the queue to be taken care of. For example, a trailer (Trailer 1) was requested at 8:00pm and was taken at 9:00pm which took 1 hour to unload/load. Meanwhile, another trailer (trailer 5) was requested at 8:33pm and is already taken care at 8:44pm within 10 mins while the trailer 1 is still sitting on the dock. I want to plot a bell-curve of how many of those trailers that are being hold for a longer time while the trailers requested later are taken care first.
    I did highlight the line items 2 and 6 in the spreadsheet attached for an example. Could someone help me figure this out? Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,059

    Re: Truck Queue/Wait Time

    Trailer 1 is in location Y while trailer 5 is in location Q, how can you compare?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Wait until weekday time
    By astrikor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2019, 10:39 AM
  2. [SOLVED] Calculating Truck Waiting Time & Truck Unloading Time
    By Aldy Johan in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-25-2017, 11:23 PM
  3. Calculating average wait time across time intervals
    By rjng90 in forum Excel General
    Replies: 7
    Last Post: 04-16-2016, 02:07 AM
  4. [SOLVED] Check the Queue Number from column H in Sheet1 and change it to Queue Name
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2014, 06:12 AM
  5. Wait time but without freezing (time to dowload data in cells)
    By bryan444 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2012, 10:39 AM
  6. Average wait time
    By evelynl in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-08-2009, 02:32 PM
  7. How much time for Concrete Truck
    By herbieinla in forum Excel General
    Replies: 6
    Last Post: 03-27-2009, 10:54 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