以B2D2为例,夜班时间等于,三个小方块之和减去3.5。那么夜班时间这个公 ...答:请在BB4输入公式:=IF(SUM(B4:D4)-3.5<0,0,SUM(B4:D4)-3.5)+IF(SUM(E4:G4)-3.5<0,0,SUM(E4:G4)-3.5)+IF(SUM(H4:J4)-3.5<0,0,SUM(H4:J4)-3.5)+IF(SUM(K4:M4)-3.5<0,0,SUM(K4:M4)-3.5)+IF(SUM(N4:P4)-3.5<0,0,SUM(N4:P4)-3.5)+IF(SUM(Q4...