/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 vote161 views1 answer
Amd64 vs arm64 linux
VBA
0 vote127 views1 answer
Excel vba Column Name to Column Number
VBA
25 votes260 views3 answers
String to date vb
VBA
0 vote143 views1 answer
How to get value from clipboard in vbnet
VBA
1 vote137 views2 answers
Vba string length
VBA
0 vote118 views1 answer
Style percent not found vba
VBA
0 vote140 views2 answers
Open url from vba
VBA
0 vote123 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote123 views1 answer
Vba line feed
VBA
0 vote128 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA