J Jackie Oct 17, 2003 #1 I need to count the number of durations 1. Less than 1 hour 2. Between 1 & 2 hours etc. HELP!
P Peo Sjoblom Oct 17, 2003 #2 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
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
