Countif function using times

M

Mike

Hello All,

I'm using Windows and Excel XP.

I am trying to count the number of occurences of times in a certain range.
For example:

A
-----------------------
1 0:15:03 (0 hours, 15 minutes and 3 seconds)
2 0:22:45
3 0:17:33
4 0:13:22
5 0:21:00
6 0:16:01

I would like to find the number of occurences that fall between the times of
0:15:00 and 20:00 (which would be 3). I am having a problem writing the
formula =COUNTIF(A1:A6,">=0:15:00<0:20:00"). It is returning the #VALUE!
error. Not sure if the time values in A1:A6 have to be converted to a
serial number or not. Any help would be appreciated.

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top