excel 按时间计算费用 1小时以内 0-40分钟6元 40-60分钟12元 1小时以 ...答:如果没理解错就如下:=IF(A1<=60,IF(A1<=40,6*A1,12*A1),IF(MOD(A1,60)<=20,ROUNDDOWN(A1/60,0)*720,IF(MOD(A1,60)<=40,ROUNDDOWN(A1/60,0)*720+360,ROUNDUP(A1/60,0)*720)))其中 A1=分钟
求用Excel计算加班时间和迟到时间的公式答:E2 =IF(AND(WEEKDAY(C2)<=5,DAY(C2)-DAY(C3)=0),IF(HOUR(C2)<9,"未迟到","迟到"),IF(AND(WEEKDAY(C2)<=5,DAY(C2)-DAY(C3)<>0),"",IF(AND(WEEKDAY(C2)>5,DAY(C2)-DAY(C3)=0),IF(HOUR(C2)<9,"未迟到",IF(HOUR(C2)>=10,"迟到",IF(AND(HOUR(C2)=9,(30-MINUTE...