Results 1 to 8 of 8

COUNTIFS function w/greater than or equal to, and less than or equal to time values

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2014
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2007
    Posts
    4

    COUNTIFS function w/greater than or equal to, and less than or equal to time values

    Hello,

    I am new to this forum and am just beginning to explore all the functions of Excel 2007 (so my terminology and understanding may not be up to par).

    I am currently creating a workbook that will pull data from patient sign in times to see how long their wait time was, to improve our offices efficiency.

    I want to count patients at different time intervals to see which step in our prep process takes the longest:
    0-3 minutes, 4-6 minutes, 7-9 minutes, and >10 minutes

    Example; The formula that I have in my cell is: =COUNTIFS(E2:E18,">=0:04",E2:E18,"<=0:06") which pulls 2 patients. However, when manually counting the data, the total amount of patients should be 3

    Is there another formula I should be using?

    I also tried: =COUNTIFS(C2:C18,">0:03",C2:C18,"<0:07") but that is counting the data for 3 minutes and 7 minutes, which I don't want.

    If you view the attachment: The data and formulas that I have in the total wait time section works perfectly with the same formulas described above.

    Very confused here,
    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional format time if less/equal to greater than a cell
    By lradney in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2014, 04:05 PM
  2. Counting values in ColA is greater or equal to those in ColB
    By Hugh Evans in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2012, 08:20 AM
  3. Counting values greater than or equal to those in another column
    By andyr85 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-26-2010, 04:15 PM
  4. Replies: 4
    Last Post: 04-24-2008, 10:08 AM
  5. Greater than or equal too IF function
    By Mavericks in forum Excel General
    Replies: 4
    Last Post: 01-06-2007, 02:15 PM

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