/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 vote197 views1 answer
Excel vba remove formatting from cell
VBA
1 vote205 views1 answer
How to put a gridpain in a vbox
VBA
6 votes201 views1 answer
Excel vba isalpha
VBA
22 votes267 views1 answer
Xlvba check for folder
VBA
1 vote203 views1 answer
Excel date to unix timestamp
VBA
0 vote198 views1 answer
Vba min
VBA
0 vote182 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote253 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote214 views1 answer
Vba cell all borders
VBA
22 votes264 views1 answer
Excelvba check for directory
VBA