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.
Click to expand...
 
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

Similar Threads

I need Time Range to return Value 4
Question: How many occurences in date range? 5
How do I find a match for three variables to determine the result? 2
airline standby worksheet 7
time_report_date-wise_employee-wise 6
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0
Over time? 4
Time query 9

Top