|
- Sub Macro1()
- Dim arr, brr, i&, j%
- arr = Range("a1").CurrentRegion
- y = Year([d2]): m = Month([d2])
- t = Day(DateSerial(2015, m + 1, 0))
- ReDim brr(1 To t + 1, 1 To 5)
- For i = 2 To UBound(arr)
- x = Split(arr(i, 4))
- d = Day(x(0)): sj = x(1)
- If Val(arr(i, 5)) = 6 Then
- If sj > "11:00:00" And sj < "14:00:00" Then brr(d, 4) = brr(d, 4) + 1
- If sj > "16:00:00" Then brr(d, 5) = brr(d, 5) + 1
- Else
- If sj > "11:00:00" And sj < "14:00:00" Then brr(d, 2) = brr(d, 2) + 1
- If sj > "16:00:00" Then brr(d, 3) = brr(d, 3) + 1
- End If
- Next
- For i = 1 To t
- brr(i, 1) = DateSerial(y, m, i)
- For j = 2 To 5
- brr(t + 1, j) = brr(t + 1, j) + brr(i, j)
- Next
- Next
- brr(t + 1, 1) = "合计"
- [g3:h100] = ""
- Range("g3").Resize(UBound(brr), 5) = brr
- End Sub
复制代码 |
|