/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 vote219 views1 answer
Compare dates vb
VBA
0 vote234 views1 answer
Create links in msgbox in vb
VBA
0 vote213 views2 answers
Excel vba prevent save
VBA
1 vote231 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote227 views1 answer
Regex numeric digits
VBA
8 votes236 views1 answer
Excel vba make integer
VBA
0 vote214 views1 answer
Excel vba disable alerts
VBA
0 vote238 views1 answer
Search for text in every worksheet excel visual basic
VBA
1 vote223 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote242 views1 answer
Excel vba set cell value to empty
VBA