不考虑几点后为旷工，只要是9点后就算迟到的话，可以用：=INT(SUMPRODUCT((C6:AG6>TIME(9,,))*(C6:AG6-TIME(9,,)))*24)&":"&ROUND(MOD(SUMPRODUCT((C6:AG6>TIME(9,,))*(C6:AG6-TIME(9,,)))*24,1)*60,0)
