/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 vote287 views1 answer
Vba like with wildcard
VBA
-1 vote304 views1 answer
How save excel through visual basic
VBA
0 vote284 views1 answer
Excel run macro every 5 minutes
VBA
25 votes415 views3 answers
String to date vb
VBA
0 vote312 views1 answer
Move bindingnavigator vb
VBA
0 vote300 views1 answer
Excel vba prevent saving workbook
VBA
0 vote316 views2 answers
Excel vba number format file size
VBA
1 vote284 views1 answer
Add control vb
VBA
0 vote314 views1 answer
Vba count all row
VBA
0 vote300 views1 answer
Vbscript remove spaces from string
VBA