/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 vote308 views1 answer
How to sort datagridview in vb.net
VBA
0 vote333 views1 answer
Excel vba hide columns
VBA
0 vote345 views1 answer
Vb run command
VBA
5 votes398 views1 answer
Excel-vba get integer high byte
VBA
1 vote354 views1 answer
Vba refresh pivot table
VBA
0 vote389 views1 answer
Excel vba set cell value to empty
VBA
0 vote360 views1 answer
VBA Loop to range
VBA
5 votes378 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote348 views1 answer
Vbscript check if string is empty
VBA
0 vote351 views1 answer
Excel vba formatconditions positive
VBA