/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 vote200 views1 answer
Excel vba protect shapes
VBA
3 votes191 views1 answer
Vba http request json
VBA
0 vote189 views1 answer
Vb ternary
VBA
0 vote180 views1 answer
Vba code to open a file with login rights
VBA
0 vote190 views1 answer
Excel run macro every 5 minutes
VBA
0 vote172 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote195 views1 answer
Freeze panes vba
VBA
1 vote169 views2 answers
Excel vba password protect
VBA
6 votes183 views1 answer
Excel vba get the path of current workbook
VBA
0 vote180 views1 answer
Vba format currency
VBA