可能原因:H与I列时间数据有“日期”(如:2019-10-29 08:54:30),导致出错。解决方法,修改公式为:=IF(H10="","未打卡",IF(MOD(H10,1)>TIME(9,0,),"迟到","正常"))