/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 vote159 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote188 views1 answer
Vba excel parser xml
VBA
1 vote168 views1 answer
Extract the second word in a text in excel
VBA
0 vote137 views1 answer
Excel vba milliseconds
VBA
0 vote159 views1 answer
Vba listbox remove all items
VBA
0 vote152 views1 answer
Vba get application version
VBA
0 vote148 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote154 views1 answer
Vba array dimensions
VBA
31 votes258 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote162 views1 answer
Excel vba set cell value to empty
VBA