/VBA/How to use if condition in time vba

How to use if condition in time vba

If Time > TimeValue("6:30:00") And Time <= TimeValue("14:30:00") Then Range("F" & Target.Row) = "1st Shift"


If Time > TimeValue("14:30:01") And Time <= TimeValue("23:30:00") Then Range("F" & Target.Row) = "2nd Shift"


If Time > TimeValue("23:30:01") And Time <= TimeValue("6:30:00") Then Range("F" & Target.Row) = "Overtime"

Source: stackoverflow.com

Similar codes

1 vote201 views1 answer
Excel vba autofit
VBA
0 vote209 views1 answer
Vba sheet visible
VBA
-1 vote200 views1 answer
For i in range vba
VBA
0 vote216 views1 answer
Vba get workbook name
VBA
0 vote213 views1 answer
Search in richtextbox vb.net
VBA
0 vote208 views2 answers
Excel vba protect cells with formula
VBA
4 votes213 views1 answer
Vba create directory
VBA
0 vote219 views1 answer
Do while not vb.net
VBA
5 votes227 views1 answer
Excel vba low word from Long Integer
VBA
0 vote229 views1 answer
Vba boolean to string
VBA