If have ths piece of code below that I need some help putting some error control around.
If (ID=11744) or (ID = 1215) or (ID=1217) or (ID=1218) or (ID=1219) Then
arrTime = Split(ItemsWorked, ":")
Itemsworked = arrTime(0) * 60 + arrTime(1)
End If
The users should enter in numbers in the format of 12:13, if they do the code work and sums up fine. If they enter nothing or just one value such as 12 and does'nt ":" then it throws and error
If (ID=11744) or (ID = 1215) or (ID=1217) or (ID=1218) or (ID=1219) Then
arrTime = Split(ItemsWorked, ":")
Itemsworked = arrTime(0) * 60 + arrTime(1)
End If
The users should enter in numbers in the format of 12:13, if they do the code work and sums up fine. If they enter nothing or just one value such as 12 and does'nt ":" then it throws and error