/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 vote225 views2 answers
Vba remove first 2 characters from string
VBA
0 vote267 views1 answer
VBA
VBA
0 vote263 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote241 views1 answer
Excel run macro every 5 minutes
VBA
0 vote238 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote241 views1 answer
Enable macros on opening workbook vba
VBA
0 vote234 views1 answer
Remove last 8 characters from string vb
VBA
0 vote284 views1 answer
Excel vba round to whole number
VBA
5 votes258 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote316 views1 answer
Excel vba delete columns in range
VBA