/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 vote199 views1 answer
Hello world vb.net
VBA
2 votes193 views1 answer
Vba array contains
VBA
0 vote198 views1 answer
Vb net check if file exists
VBA
1 vote189 views2 answers
Vba string to date
VBA
5 votes147 views1 answer
Vlookup vba
VBA
0 vote232 views1 answer
Vba registry settings
VBA
0 vote204 views1 answer
Vba get application version
VBA
0 vote209 views1 answer
Vba paste values
VBA
0 vote254 views1 answer
Excel vba protect content
VBA
0 vote208 views1 answer
Vba file chooser
VBA