lulututu

2020-06-10   阅读量: 104

在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 关注作者 收藏

评论(1)

傅奕程
2020-06-10
马克
0.0033 1 0 回复

推荐帖子


    暂无数据

推荐课程