+ Reply to Thread
Results 1 to 2 of 2

Countifs function

  1. #1
    Registered User
    Join Date
    02-11-2008
    Posts
    1

    Countifs function

    9:00 PM
    8:04 PM
    8:07 PM
    9:01 PM
    10:01 PM
    10:03 PM
    10:59 PM
    11:09 PM
    11:05 PM
    11:59 PM

    2 8-8:59 pm
    2 9-9:59 pm
    3 10-10:59 pm
    0 11-11:59 pm

    I am trying to take a long column of time entries (2107 of them) and count the number of times that fall within a specific hour. Using the formula below with only changes in times works fine except when I count the 11-11:59 PM. Could certainly use some help.

    =COUNTIFS(E1:E10,">=11:00 PM",E1:E10,"<12:00 PM")

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Hi Jerry

    12pm on the 24hour clock is 12:00 whereas 11pm is 23:00 - hence the mismatch. if you only have times in these cells, then you can use a simple COUNTIF as you want to count all the cells above 11pm:

    =COUNTIF(E1:E10,">=11:00 PM")

    Richard
    Richard Schollar
    Microsoft MVP - Excel

+ 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