countif with time

N

NEHicks

Col A
09:15
12:39
10:15
09:25
11:36

I need to count the number of times there is an entry in column A that is
between 08:00-08:59, 09:00-09:59, 10:00-10:59, etc.

So the sum would be 08:00-08:59 0
09:00-09:59 2

etc.
 
T

Teethless mama

NEHicks said:
Col A
09:15
12:39
10:15
09:25
11:36

I need to count the number of times there is an entry in column A that is
between 08:00-08:59, 09:00-09:59, 10:00-10:59, etc.

So the sum would be 08:00-08:59 0
09:00-09:59 2

etc.
 
C

Chelsea

Hi,Nehicks,

try

=SUMPRODUCT((($A$1:$A$5)>=TIME(8+ROW()-1,0,0))*(($A$1:$A$5)<TIME(8+ROW(),0,0))*1)

p.s. make sure the data format is time

HTH

Chelsea
 

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