Counting if a time is within a specified range

  • Thread starter Thread starter Tomster27
  • Start date Start date
T

Tomster27

I have a list of times (part of which is included below). I want to be able
to count them if they fall between the times of 01:00 and 16:00 and ignore
them if they fall outside those times. I have tried COUNTIF but have got very
badly stuck. I would be very grateful for any help

20:26
10:15
23:24
1:45
15:23
15:57
5:01
14:18
 
try this array formula, confirm by Ctrl, Shift and Enter

=SUM((A2:A9>=TIME(1,0,0))*(A2:A9<=TIME(16,0,0)))

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis
 
Back
Top