/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 vote115 views1 answer
Vba apostrophe chr
VBA
0 vote136 views1 answer
How to mount floppy disks in vb.net
VBA
5 votes128 views1 answer
Excel vba low byte from INTEGER
VBA
22 votes215 views1 answer
Xl vba check for folder
VBA
0 vote80 views1 answer
How to self delete a vbscript file
VBA
2 votes125 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote136 views1 answer
Excel vba urlmon
VBA
0 vote124 views1 answer
Arq linux
VBA
0 vote139 views1 answer
Build an index all files of a FTP site
VBA
5 votes121 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA