统计時間區段个数多少 (8969)

時間區段需依序F2=COUNTIFS(A:A,">="&"2021/10/11"+(ROW(A1)-1)/24,A:A,"<"&"2021/10/11"+ROW(A1)/24-1/86400)

依E列時間區段可隨意G2=COUNTIFS(A:A,">="&"2021/10/11"+LEFT(E2,FIND("-",E2)-1),A:A,"<"&"2021/10/11"+MID(E2,FIND("-",E2)+1,9)+1/1440)