COUNTIF

[Jackie]

I need to count the number of durations
1. Less than 1 hour
2. Between 1 & 2 hours
etc.
HELP!

 

[Peo Sjoblom]

For less than 1 hour

=COUNTIF(A1:A10,"<"&TIME(1,,))

between 1 and 2

=COUNTIF(A1:A10,">="&TIME(1,,))-COUNTIF(A1:A10,">"&TIME(2,,))

you might want to change the latter to

=COUNTIF(A1:A10,">="&TIME(1,,))-COUNTIF(A1:A10,">="&TIME(2,,))

if you don't want to include 02:00

format result as general or else you might get a time format