计算员工平时加班和周末加班的公式，各位大神有什么好的公式可以一起讨论

程建霞

2020-04-20 阅读量: 2208

我的公式：平时加班=SUMIFS(H5:AK5,$H$3:$AK$3,">1",$H$3:$AK$3,"<7",H5:AK5,">8")-COUNTIFS($H$3:$AK$3,">1",$H$3:$AK$3,"<7",H5:AK5,">8")*8

周末加班=SUMIF(H$3:AL$3,1,H5:AL5)+SUMIF(H$3:AL$3,7,H5:AL5)

各位大神有什么更简单的方法么？

98.4329

关注作者

发表评论

188****3139

2020-04-21

=SUMIFS(H5:AK5,$H$3:$AK$3,">1",$H$3:$AK$3,"<7")-B5*8

93.5590 3 0 回复

陈革007

2020-04-20

=SUMIFS(H4:AL4,$H$2:$AL$2,"<>1",$H$2:$AL$2,"<>7")-B4*8

100.2456 5 0 回复

CDA考试动态

CDA报考指南

推荐帖子