2020-06-10
阅读量:
1957
在excel制作员工考勤表
计算出勤天数：=COUNTIFS($H$3:$AL$3,">=2",$H$3:$AL$3,"<=6",H5:AL5,">=8")
计算病假：=COUNTIF(H5:AL5,"病")
计算事假：=COUNTIF(H5:AL5,"事")
计算平时加班：=SUMIFS(H5:AL5,$H$3:$AL$3,">=2",$H$3:$AL$3,"<=6",H5:AL5,">=8")-B5*8
计算周末加班：=SUMIF($H$3:$AL$3,1,H5:AL5)+SUMIF($H$3:$AL$3,7,H5:AL5)
通过合并计算计算员工两个月的出勤合计
44.4695
6
2
关注作者
收藏
发表评论
