Count times in a specific range

=COUNTIFS(rng,">="&start,rng,"<"&end)
To count times that occur within a certain range, you can use the COUNTIFs function. In the example shown, the formula in E7 is:
=COUNTIFS(B5:B11,">="&E5,B5:B11,"<"&E6)
The COUNTIFS function takes one or more criteria, entered as range/criteria pairs. In this example, the first range/criteria pair is:
B5:B11,">="&E5
Matching any time greater than or equal to the time E5 (5:00).
The second range/criteria pair is:
B5:B11,"<"&E6
Matching any time less than the time in E6 (6:30).
With hard-coded values
The formula in E7 could be written with hard-coded time values as follows:
=COUNTIFS(B5:B11,">=5:00",B5:B11,"<6:30")
Excel translates a string like "5:00" into the correct numeric time value.
With the TIME function
The formula in E7 could be written with the TIME function like this:
The TIME function provides a simple way to assemble a valid time using discreet hour, minute, and second values.
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.