Countif - Counting time in a Column

T

TRM

I am trying to count the occurances of time in a column e.g how many calls
were received between 07:00:00 and 17:0:00 Does anyone know a formula that
works for time?
 
B

B. R.Ramachandran

Hi,

Supposing that the time data are in A2....A100, to count the number of calls
that were received between 07:00:00 (enter this B2) and 17:00:00 (enter this
in C2), and in D2 enter the following formula and click Enter.

=SUMPRODUCT((A2:A100>=B2)*(A2:A100<=C2))

Regards,
B. R. Ramachandran
 
T

tjtjjtjt

Here's another version:
=SUMPRODUCT(--(A1:A22>=TIME(7,0,0)),--(A1:A22<=TIME(17,0,0)))
 
Top