+ Reply to Thread
Results 1 to 2 of 2

Determining How Many Entries are with 2 hours

  1. #1
    Registered User
    Join Date
    07-08-2017
    Location
    Roanoke, VA
    MS-Off Ver
    2013
    Posts
    1

    Determining How Many Entries are with 2 hours

    I am currently working with a data log with dates and times for work. We do ambulance dispatching and are attempting to determine what calls for service have another entry within two hours (IE: Ambulance is requested and there were 3 other calls for service in the past two hours) to determine when the system has potential to be overloaded.

    I have times in "MM/DD/YYY HH:MM:SS" format in one column so I know there is probably a simple way to calculate this (either as a formula or a conditional formatting rule) but it is completely stumping me.

    Any suggestions??

  2. #2
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    514

    Re: Determining How Many Entries are with 2 hours

    Maybe

    =COUNTIFS(A:A,"<="&A2,A:A,">"&A2-"2:00")

+ 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. Replies: 5
    Last Post: 04-13-2017, 11:05 AM
  2. Replies: 3
    Last Post: 06-18-2014, 07:26 AM
  3. Determining how many hours are in a time range
    By lesoies in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-05-2013, 06:19 AM
  4. Help: Determining TAT based on business hours... weekends included
    By dagbruinsfan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2013, 10:34 AM
  5. Formula for determining end date after N number of hours
    By prosavage2600 in forum Excel General
    Replies: 0
    Last Post: 09-21-2011, 04:22 PM
  6. Determining duplicate entries and frequency
    By Tissy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-20-2009, 10:08 PM
  7. [SOLVED] Formula for determining number of hours?
    By Susan in forum Excel General
    Replies: 1
    Last Post: 06-30-2006, 02:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1