Sub 按钮5_Click()
Dim arr As Range
Set arr = Range("A2:j8")
ReDim brr(1 To arr.Rows.Count, 1 To 2)
For r = 1 To arr.Rows.Count 'Step 2
If arr(r, "b") = arr(r + 1, "b") Then
flag = arr(r, "j") = "入" And arr(r + 1, "j") = "出"
If flag Then brr(r, 1) = (arr(r + 1, "g") + arr(r + 1, "h") - (arr(r, "g") + arr(r, "h"))) * 24 * 60
flag = arr(r, "j") = "出" And arr(r + 1, "j") = "入"
If flag Then brr(r, 2) = (arr(r + 1, "g") + arr(r + 1, "h") - (arr(r, "g") + arr(r, "h"))) * 24 * 60
End If
Next
[k2].Resize(arr.Rows.Count, 2) = brr
End Sub