如图，在excel中怎么用公式计算出时间在0点至1点之间的数有多少条！急急急！在线等！

Question

如题所述

Answer 1

=COUNTIF(A:A,">=0:0:0")-COUNTIF(A:A,">0:59:59")
2007版可用公式：
=COUNTIFS(A:A,">=0:0:0",A:A,"<1:0:0")

Answer 2

=SUM(COUNTIF(data,{">00:00:00",">=00:01:00"})*{1,-1})

Answer 3

Answer 4

我的做法是分列，用冒号作为分列标识，然后计算第二列在00-01之间有多少个数就知道了