=IF(A3="","未打卡",IF(A3>--"08:30","迟到",""))D3公式下拉:=IF(B3="","未打卡",IF(B3<--"17:30","早退",""))
可以用字串函数来解决,举例如下:其中,F11是要检查的时间记录所在单元格,740指早晨7:40.=IF(IF(LEFT(RIGHT(F11,5),1)<>"1",LEFT(RIGHT(F11,4),1)*100,LEFT(RIGHT(F11,5),2)*100)+RIGHT(F11,2)>740,"...
用IF函数,=IF(A1>TIME(8,0,0),"迟到","未迟到")
H2="迟到"&IF(HOUR(F2)>--"9:00",ROUNDUP((MOD(F2,1)-"9:00")*1440,)&"分钟","")或=TEXT(ROUNDUP((MOD(F2,1)-"9:00")*1440,),"迟到0分钟;;")下拉(未满
if(迟到时间<10分钟){扣分数=-5;}elseif(迟到时间<1小时){扣分数=-5+(迟到时间-10分钟)*(-1);}else{扣分数=-55+(迟到时间-1小时)*(-100);}...
如图早上的迟到与缺勤迟到公式=IF(A2>(7/24+45/1440),"迟到","")缺勤公式=IF(A2,"","缺勤")
你可以用IF函数=IF(到班时间>标准时间,"迟到","没迟到")注意标准时间的锁定。迟到时间=SUM(到班时间-标准时间)注意,标准时间锁住。缺勤次数:先用计数函数求出他的考勤次数=COUNTA(区域),缺勤次数=SUM(全勤次数-他的考勤次数)...
WPS表格做考勤用IF函数无法判断是否迟到,那是因为判断时间应该用TIME函数,而不是用双引号将时间括起来,那样会被认为是文本的,而时间是数字,正确公式如下:=IF(F3<TIME(7,45,1),0,1)注:用TIME函数输入三个参数后...
B3=IF(B2="","没打卡",IF(B2<=--"12:00:00","正常","迟到"))向右复制L2=COUNTIF($B2:$K2,">12:00:00")M2=COUNTIF($B2:$K2,"<=12:00:00")N2=CO
=IF(AND(A2,C2=""),"未打卡",TEXT(INT((C2-"9:30")*24*60),"迟到0分;;;"))下拉