Excel Forum



Excel Magic Trick 441: Count Times That Start With 7 (7:00, 7:15, etc.)


See how to count the number of times in a list of times that begin with 7. Example 1:30, 7:00, 7:34, 6:00 would be a count of 2. See the functions HOUR, TEXT and SUMPRODUCT.





Got a Question? Ask it Here in the Forum.