|
你看一下
Option Explicit
Public Function 时间(ss As Variant, Optional sss As Boolean = True)
Dim sz As Variant, i As Integer, zhi1 As String, zhi2 As String
sz = Split(ss, Chr(10))
'早上8点后签到为迟到
For i = 0 To UBound(sz)
If Len(sz(i)) = 5 Then
If TimeValue(sz(0)) < TimeValue("08:00") Then
zhi1 = sz(0)
zhi2 = "正常"
Else
zhi2 = "迟到"
End If
If TimeValue(sz(i)) > TimeValue("13:30") And TimeValue(sz(i)) < TimeValue("14:00") Then
zhi1 = zhi1 & sz(i)
Exit For
Else
zhi2 = "异常"
End If
End If
Next
If sss Then
时间 = zhi1
Else
时间 = zhi2
End If
End Function
|
|