Sub test()
Dim rq As Date
rq = InputBox("请输入时间:")
n = 35
ReDim arr(1 To n, 1 To 1)
arr(1, 1) = rq
For i = 2 To n
p = Rnd * 3 + 3
arr(i, 1) = arr(i - 1, 1) + p / 60 / 24
Next
For i = 1 To n
arr(i, 1) = Format(arr(i, 1), "hh/mm/ss yyyy/mm/dd")
Next
For m = 1 To 35
Range("a" & (m - 1) * 9 + 2) = arr(m, 1)