COUNTIF using amount of time

Giganews Newsgroups
Subject: COUNTIF using amount of time
Posted by:  dman (dennis.m…@gmail.com)
Date: 23 Jan 2007

I have some data with various time intervals in mm:ss.ms and I want to
use the COUNTIF function to count how many of them fall between 1-2
minutes, 2-3 minutes, 3-4 minutes, etc., but I keep getting a count of
all the values. Am I comparing the time intervals wrong?

For example, the data (in the A column) is:
01:19.666
01:13.287
01:28.308
02:29.872
05:36.658
01:01.770

My formula for counting those between 1-2 minutes:
=COUNTIF(A:A,">=00:01.000&&<00:02.000")

The returned value is 6.

Any help would be appreciated,
Dennis

Replies