/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

0 vote196 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote180 views1 answer
Excel vba current folder
VBA
1 vote191 views1 answer
Excel vba to lower case
VBA
0 vote195 views1 answer
Vba sort multiple columns
VBA
0 vote180 views1 answer
Excel vba disable keyboard input
VBA
0 vote238 views1 answer
Visual basic run command
VBA
1 vote179 views1 answer
Excel vba compare 2 rows
VBA
0 vote197 views1 answer
Vbscript check if string contains
VBA
0 vote187 views1 answer
Excel vba disable mouse click
VBA
0 vote192 views1 answer
Vba word open document read only
VBA