/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

2 votes178 views2 answers
Vba exit loop
VBA
1 vote239 views1 answer
Excel vba autofit
VBA
3 votes248 views1 answer
Vba not equal
VBA
0 vote257 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote193 views1 answer
Vba set vs dim
VBA
0 vote250 views1 answer
Vba array of integers
VBA
-1 vote236 views2 answers
How close excel through visual basic
VBA
0 vote256 views1 answer
Windows Forms dark title bar
VBA
2 votes241 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
22 votes539 views1 answer
Xlvba check for folder
VBA