/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 vote321 views1 answer
Excel vba array remove first
VBA
0 vote318 views1 answer
Vba copy file
VBA
0 vote320 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote343 views4 answers
Vgrive,deb
VBA
-1 vote304 views1 answer
Text to speech vb.net
VBA
1 vote323 views2 answers
Vba function return array
VBA
0 vote317 views1 answer
String contins in vba
VBA
0 vote323 views1 answer
Excel vba select multiple shapes
VBA
3 votes311 views1 answer
Vba folderexists
VBA
0 vote320 views1 answer
Vba collection key list
VBA