a列下班时间 b列上班时间 c1输入=（b1-a1）*24-1下拉d1输入=countif（c:c,">=8"）e1输入=countif（c:c,">=7.5"）-d1f1输入=countif（c:c,">=5"）-countif（c:c,">=7.5"）g1输入=countif（c:c,">=3"）-countif（c:c,">=5"）h1输入=countif（c:c,"<3"）
