发布网友 发布时间:2022-04-22 08:10
共2个回答
热心网友 时间:2022-06-18 09:38
A列是全部日期
B2=TEXT(WEEKDAY(A2,1),"aaaa"),往下拖
C2手填
C3=INDEX($H$1:$H$15,SUMPRODUCT(0+($F$2:$F$15=B3),0+($G$2:$G$15=C2),ROW($H$2:$H$15))),往下拖
D2=IF(AND(WEEKDAY(A2,1)>2,WEEKDAY(A2,1)<6),IF(C2="A","B","A"),IF(C2="A","A","B")),往 下拖
F到H列是排班的清单参考表,可以按我写的
K1和K2是查询班次的起止日期
K5=COUNTIFS($A:$A,">=" &$K$1,$A:$A,"<=" &$K$2,C:C,"=A"),往 右拖
K6=COUNTIFS($A:$A,">=" &$K$1,$A:$A,"<=" &$K$2,C:C,"=B"),往 右拖
本例没有做节假日,节假日需要手动改一下,后续会自动变化的
热心网友 时间:2022-06-18 09:39
工时怎么个统计法,把问题作为内容(邮件主题一定要包含“excel”,本人以此为依据辨别非垃圾邮件,以免误删),excel样表文件(把现状和目标效果表示出来)作为附件发来看下 yqch134@163.com