Home » Posts

Count times in a specific range

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,"

April 14, 2025 · 1 min · 42 words · Brian Hansen

Table of Contents

Explanation

TheCOUNTIFS functiontakes one or more criteria, entered as range/criteria pairs.

The second range/criteria pair is:

Matching any time less than the time in E6 (6:30).

The TIME function is useful when you want to assemble a proper time inside another formula.

Excel formula: Round time to nearest 15 minutes

Excel formula: Calculate hours between two times

Excel formula: Extract time from a date and time

Excel formula: Group times into 3 hour buckets

Excel COUNTIFS function

Excel TIME function

Explanation#

Explanation