从考勤系统里导出打卡时间(成EXCEL表)计算加班时间答:举例说明。例如有数据表如图:第一步:在E2输入公式:=ROUND((IF(OR(WEEKDAY(B2,2)=6, WEEKDAY(B2,2)=7),0,D2-C2-9/24))*24,1),然后拖动至E25.第二步:在F2输入公式:=ROUND((IF(OR(WEEKDAY(B2,2)=6, WEEKDAY(B2,2)=7),D2-C2-9/24,0))*24,1),然后拖动至F25.第三步...
求用Excel计算加班时间和迟到时间的公式答:)G2 =IF(E2<>"","",IF(WEEKDAY(C2)>5,IF(AND(HOUR(C2)=17,MINUTE(C2)>30),"加班",if(AND(HOUR(C2)>=18,"加班","未加班")),IF(HOUR(C2)>=18,"加班","未加班")))H2 =TEXT(IF(OR(G2="",G2="未加班"),"",(IF(WEEKDAY(C2)>5,TEXT(TEXT(C2,"hh:mm"),"G/通用...