+ Reply to Thread
Results 1 to 4 of 4

Calculating longest waiting time at given time slot

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    Calculating longest waiting time at given time slot

    Hi there

    I have a sheet with arrival and departure times. The sheet has calculations to work out how many people where on the premises at a given time slot. I'd also like to longest waiting time at a given time slot. For example, at 08:00 there might be 5 people on the premises with the longest waiting time of these 5 people being 17 mins.

    Thanks in advance.

    Chart 1.xlsx

  2. #2
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

    Re: Calculating longest waiting time at given time slot

    Try this in H2 (see attached):

    =B2-A2

    Then, in H2 right click -Format Cells- and set the cell to this custom format [H]:mm

    The square brackets return the value as elapsed time.
    Attached Files Attached Files

  3. #3
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Calculating longest waiting time at given time slot

    Try using:

    Please Login or Register  to view this content.
    Confirmed as an array formula with Ctrl-Shift-Enter. Custom format the cell as "[h]:mm:ss"
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  4. #4
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Calculating longest waiting time at given time slot

    Exactly what I was looking for ConneXionLost. Thank you so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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