Results 1 to 7 of 7

Count instances that happen within time range

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    Buffalo
    MS-Off Ver
    Excel 2007
    Posts
    16

    Count instances that happen within time range

    Okay I have a workbook with multiple sheets. On each sheet is a list of service calls. The time a service call is received is formated as General ex "02:05:00". I want to count how many times a service call is late between hours of the day ex 00:00:00 - 01:00:00 , 01:00:00 - 02:00:00 and so on. There is a column next to the service call received time that will have "Late" in it if the call was late. I have tried a few different formulas but just can't get it to count them.

    This is the most recent formula i have tried (obviously i would have to add the "Late" criteria but even without that it wont count).

    =COUNTIFS(CAO!$X$21:$X$500,">="&TIME(2,0,0),CAO!$X$21:$X$500,"<"&TIME(3,0,0))
    Last edited by Abarency; 06-12-2013 at 03:09 PM.

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