考勤表如何用excel进行归类上下班时间。。
考勤表如何用excel进行归类上下班时间。。
日期：2022-02-27 19:43:25 人气：1
1.可以按姓名和时间分别为主要、次要关键字排序。
2.在D2中输入
=IF(AND(B2>TIME(9,0,0),B2<TIME(12,0,0)),"迟到"&TEXT(B2-TIME(9,0,0),"h时mm分"),"")&IF(B2>TIME(16,30,0),"早退"&TEXT(TIME(16,30,
2.在D2中输入
=IF(AND(B2>TIME(9,0,0),B2<TIME(12,0,0)),"迟到"&TEXT(B2-TIME(9,0,0),"h时mm分"),"")&IF(B2>TIME(16,30,0),"早退"&TEXT(TIME(16,30,