- =IF(AND(MIN(C4:F4)<TIME(11,30,0),MIN(C4:F4)>TIME(8,0,0)),"上午迟到"&TEXT(MIN(C4:F4)-TIME(8,0,0),"h:mm:ss"),"")&IF(AND(SMALL(C4:F4,2)<TIME(11,30,0),SMALL(C4:F4,2)>TIME(8,0,0)),"上午早退"&TEXT(LARGE(C4:F4,2)-TIME(12,30,0),"h:mm:ss"),"")&IF(AND(LARGE(C4:F4,2)<TIME(17,0,0),LARGE(C4:F4,2)>TIME(12,30,0)),"下午迟到"&TEXT(LARGE(C4:F4,2)-TIME(12,30,0),"h:mm:ss"),"")&IF(AND(MAX(C4:F4)>TIME(12,30,0),MAX(C4:F4)<TIME(17,0,0)),"下午早退"&TEXT(TIME(17,0,0)-MAX(C4:F4),"h:mm:ss"),"")
复制代码 使用了一个比较复杂的显示方式,看看这样是否可以
因为不知道您想要怎么样显示,只好按自己的想法都显示出来了 |