=IF(F2-"8:30">5/1440,"迟到","")&" "&IF("17:30"-G2>5/1440,"早退","")下拉复制公式(公式中假设提前5分钟离岗的为迟到)如果只要计算迟到的=IF(F2-"8:30">5/1440,"迟到","") 下拉复制公式这样就行了
