统计每人每个月请假的时间答:高难度啊,不过excel是无敌的!待我做给你看:需要你在sheet1里原因后面再加两列,D列(请假类型),E列(小时)D2公式:=LEFT(C2,2)E2公式:=IF(D2="病假",IF(RIGHT(C2)="天",SUBSTITUTE(SUBSTITUTE(C2,"天",""),"病假","")*8,SUBSTITUTE(SUBSTITUTE(C2,"小时",""),"病假","")*...
excel中病事假扣除天数的函数公式答:=IF(I2="病假",IF(J2<=10,0,IF(J2<20,J2,30)),IF(I2="事假",IF(J2<=1,0,IF(J2<10,J2,30)),IF(I2="旷工",30,"")))