/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 vote165 views2 answers
Excel vba close without saving
VBA
-1 vote160 views1 answer
Text to speech vb.net
VBA
0 vote128 views1 answer
Vbide vbproject reference
VBA
1 vote124 views1 answer
How to open cmd with vbd
VBA
7 votes174 views1 answer
Vba array declaration
VBA
4 votes177 views2 answers
Excel vba last column with data
VBA
0 vote174 views1 answer
Sort dictionary by key vba
VBA
0 vote182 views1 answer
Vbnet round to nearnest thousand
VBA
4 votes168 views1 answer
Excel vba how to reset usedrange
VBA
0 vote231 views1 answer
Excel vba add reference programmatically
VBA