COUNTIF for times????

[RiceKrispy]

Okay,

I've never done this before I admit....

I need to see the volume based on time of day. I have multiple times in a column, i.e 9:23, 12:18, 20:21, 11:58, etc.

It would be cool to track how many were between (for example)
9:00 AM and 9:30 AM (or 10:00 AM)
15:00 to 16:00 (i.e. 3 PM to 4 PM)

Any help would be greatly appreciated!

Thanks in advance!

[Ron Coderre]

With Col_A containing your time values
Try this:
D1:D7 contains these time values:
09:00 AM
09:30 AM
10:00 AM
10:30 AM
11:00 AM
11:30 AM
12:00 PM
(extend that list as far as you need)

And...This regular formula begins the list of time counts that are greater than or equal to D1 but less than D2
D1: =COUNTIFS($A$1:$A$200,">="&D1,$A$1:$A$200,"<"&D2)

Copy that formula down for the successive counts.

Is that something you can work with?

[RiceKrispy]

Maybe!

I do have this formula:

=COUNTIF(B:B,">0:00")-COUNTIF(B:B,">=1:00")

HOWEVER, it doesn't count every single time; for instance, this formula counted 125 times, when I counted there are 129 times in this range.