|
- Sub 时间修改()
- Dim arr, h As Integer, i As Integer
- With Sheet1
- h = .Range("a" & .Rows.Count).End(xlUp).Row
- arr = .Range("a1:b" & h)
- For i = 1 To UBound(arr)
- If VBA.Split(arr(i, 2), ":")(0) < 10 Then
- arr(i, 2) = "23:00"
- arr(i, 1) = arr(i, 1) - 1
- End If
- Next
- .Range("A1").Resize(UBound(arr), 2) = arr
- End With
- End Sub
复制代码 |
|