/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 vote157 views1 answer
Vba copy paste value only
VBA
0 vote169 views1 answer
Loop through lines in text file vb net
VBA
0 vote218 views1 answer
How to call gcd in vba
VBA
7 votes175 views1 answer
Excerl vba array to range
VBA
1 vote153 views1 answer
How to do error handling in access vba
VBA
1 vote172 views1 answer
Excel vba force recalculation
VBA
5 votes179 views1 answer
Excel formula how to create strings containing double quotes
VBA
25 votes249 views3 answers
String to date vb
VBA
1 vote189 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote184 views1 answer
Vb run command
VBA