|
所有打卡记录都出来,用这个可以参照!!!
Function aa(aa1)
If aa1 >= #7:30:00 AM# And aa1 <= #8:00:00 AM# Then
ab = "A"
If aa1 >= #3:30:00 PM# And aa1 <= #4:00:00 PM# Then
ab = "B"
If aa1 >= #11:30:00 PM# And aa1 <= #12:00:00 PM# Then
ab = "C"
Else
ab = 0
End If
End If
End If
End Function
Function bb(bb1)
If bb1 >= #4:00:00 PM# And bb1 <= #4:30:00 PM# Then
ab = "a"
If bb1 >= #12:00:00 PM# And bb1 <= #12:30:00 PM# Then
ab = "b"
If bb1 >= #8:00:00 AM# And bb1 <= #8:30:00 AM# Then
ab = "c"
Else
ab = 0
End If
End If
End If
End Function
Sub aaaa()
On Error Resume Next
For i = 1 To [a65536].End(3).Row
For j = 4 To Cells(i, 4).End(2).Column
aaa = aaa & " " & aa(Cells(i, j).Value)
bbb = bbb & " " & bb(Cells(i, j).Value)
Next j
If (InStr(1, aaa, "A") Or InStr(1, aaa, "B") Or InStr(1, aaa, "C")) And (InStr(1, bbb, "a") Or InStr(1, bbb, "b") Or InStr(1, bbb, "c")) Then
Cells(i, 14).Value = "打卡正常"
Else
Cells(i, 14).Value = "打卡不正常"
aaa = ""
bbb = ""
End If
Next i
End Sub
|
|