- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- COUNTIF using amount of time

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

- Re: COUNTIF using amount of time posted by George Nicholson on Tue, 23 Jan 2007
- Re: COUNTIF using amount of time posted by Earl Kiosterud on Tue, 23 Jan 2007