|
前7再顺延?
再加个判断
Sub TEST()
R = Cells(Rows.Count, 1).End(3).Row
ARR = Range("A1:U" & R)
ReDim BRR(1 To R - 1, 1 To 3)
For I = 2 To R
If ARR(I, 14) <> 0 Then
If (ARR(I, 7) - Val(ARR(I - 1, 11))) * 24 * 60 < 1 Then
Z = Z + ARR(I, 14)
Else
N = N + 1
If N < 8 Then
S = S + ARR(I, 14)
Else
Z = Z + ARR(I, 14)
End If
End If
End If
If ARR(I, 21) = "X" Then
If S > 0 Then
BRR(I - 1, 2) = S
Else
BRR(I - 1, 1) = S
End If
If Z <> 0 Then BRR(I - 1, 3) = Z
N = 0: S = 0: Z = 0
End If
Next
Range("R2").Resize(R - 1, 3) = BRR
End Sub
|
|