|  

» Counting Time Values in Terms of Hourly Increments

Problem:

Counting the number of time values in List1 (column A) that occur between each pair of successive hours listed in column B.

Solution:

Use the COUNTIF function as shown in the following formula:
=COUNTIF($A$2:$A$7,">"&B2)-COUNTIF($A$2:$A$7,">"&B3)


Rate This Tip
12 34 5
Rating: 2.33     Views: 11300
No comments have been submitted.
Name
Comment Title
Comments