|
用VBA完成,要求在附件里
本帖最后由 sunjing-zxl 于 2012-1-8 21:22 编辑
- Sub aa()
- Dim arr1, arr2
- Dim i As Long
- Dim t, h
- arr1 = Range("A2:A" & [A65536].End(xlUp).Row)
- ReDim arr2(1 To UBound(arr1), 1 To 1)
- For i = 1 To UBound(arr1)
- t = VBA.Weekday(arr1(i, 1), 2)
- h = VBA.Hour(arr1(i, 1)) + VBA.Minute(arr1(i, 1)) / 60
- If t > 5 Then
- arr2(i, 1) = "双休日"
- ElseIf h > 8.5 And h < 12 Then
- arr2(i, 1) = "迟到"
- ElseIf h > 13 And h < 17.5 Then
- arr2(i, 1) = "早退"
- End If
- Next i
- Range("B2").Resize(UBound(arr2), 1) = arr2
- End Sub
复制代码附件:
考勤-sunjing.rar
(9.51 KB, 下载次数: 39)
|
|