|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:
My formula for counting those between 1-2 minutes:
The returned value is 6.
Any help would be appreciated,