/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

2 votes216 views1 answer
Vba split string
VBA
3 votes285 views2 answers
Excel "vba" match last value
VBA
0 vote233 views1 answer
Openfiledialog specific folder
VBA
0 vote265 views1 answer
Vba dictionary length
VBA
1 vote231 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote236 views1 answer
Vba count all row
VBA
0 vote229 views1 answer
Rotate image by any angle vb.net
VBA
1 vote241 views1 answer
Extract the second word in a text in excel
VBA
0 vote345 views2 answers
VB
VBA
0 vote255 views1 answer
Amd64 vs arm64 linux
VBA