统计各时间段人数

iwanttw

想统计8点到9点一共多少人打卡？

9点到10点一共多少人打卡？

autohotey

都发了7个贴了，按道理应该知道上传附件啊。
=COUNTIF(B2:B7,">=9:00")-COUNTIF(B2:B7,">10:00")

iwanttw

autohotey 发表于 2024-12-21 14:02
都发了7个贴了，按道理应该知道上传附件啊。
=COUNTIF(B2:B7,">=9:00")-COUNTIF(B2:B7,">10:00")

你的方法好像不行，
现在上传附件了

iwanttw

autohotey 发表于 2024-12-21 14:02
都发了7个贴了，按道理应该知道上传附件啊。
=COUNTIF(B2:B7,">=9:00")-COUNTIF(B2:B7,">10:00")

可以了，刚才是我公式输错了
谢谢

leepoison

=TRANSPOSE(TAKE(FREQUENCY(VALUE(B2:B7)*24,{8,9}),-2))

autohotey

iwanttw 发表于 2024-12-21 14:33
可以了，刚才是我公式输错了
谢谢

或者你可以这样,道理都差不多：

=COUNTIFS($B:$B,">=8:00",$B:$B,"<9:00")

=SUMPRODUCT(($B:$B>=TIME(8,0,0))*($B:$B<TIME(9,0,0)))

心电感应

=COUNTIFS($B$2:$B$7,">="&TIME(7+COLUMN(A1),,),$B$2:$B$7,"<="&TIME(8+COLUMN(A1),,))

jerrike

1. =TOROW(INDEX(FREQUENCY(B2:B7,{"8:00:00","9:00:00","10:00:00"}-1%%%),{2,3}))

复制代码

沈默00

=SUM((B2:B7>=TIMEVALUE("8:00"))*(B2:B7<TIMEVALUE("9:00")))

wum2233

您看这样可以吗