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?
|