/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

8 votes289 views1 answer
Excel vba make word
VBA
0 vote229 views1 answer
Convert number to minutes in vba
VBA
1 vote216 views1 answer
What does vbs stand for
VBA
1 vote228 views2 answers
Excel vba password protect
VBA
25 votes549 views3 answers
String to date vb
VBA
0 vote224 views1 answer
Windows Presentation Foundation dark title bar
VBA
8 votes314 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote228 views1 answer
Vba check if class implements interface
VBA
0 vote221 views1 answer
Vbs write file
VBA
0 vote205 views1 answer
Le contrôle SpinButton (Toupie)
VBA