Countif - Counting time in a Column
 

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?

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

"TRM" wrote:

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?

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


"TRM" wrote:

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?