B3=IF(B2="","没打卡",IF(B2<=--"12:00:00","正常","迟到"))向右复制
L2=COUNTIF($B2:$K2,">12:00:00")
M2=COUNTIF($B2:$K2,"<=12:00:00")
N2=COUNTIF($B2:$K2,"")
=IF(I3="","没打卡",IF(I3<0.5,"正常","迟到"))
