/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 vote344 views1 answer
Find control with name vb
VBA
3 votes323 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote353 views2 answers
VB
VBA
0 vote350 views1 answer
How to enter Vbox manage commands
VBA
0 vote334 views1 answer
Ribbon show/hide
VBA
0 vote341 views1 answer
Vba createparameter null
VBA
0 vote336 views1 answer
Excel vba move down to next visible cell
VBA
0 vote340 views1 answer
Vba get workbook name
VBA
0 vote319 views1 answer
Quit excel with save changes dialog vb.net
VBA
3 votes362 views1 answer
Excel vba make long from two shorts
VBA