Dropdown List to automatically enter work shift

[dinkss]

Hi there,

I'm new to VBA and Excel. I'm trying to write formula or VBA code to be able to get EXCEL to automatically enter WORK SHIFT based on time when data was selected from dropdown list.
I have created dropdown list but now I want EXCEL to enter WORK SHIFT automatically when I select any options from dropdown list no matter what time it will be. I want excel to know if I select data at 10:00:00 that this is Day Shift and if I select Data at 19:00:00 that this is Evening Shift.

My dropdown menu is in Cells J:J and I want excel to automatically enter work shift in K:K based on time when I select information from my dropdown list.

I have attached screenshot of my worksheet.

Please help me, it is really important for me!

Thanks Guys!

 

[dinkss]

These are the shifts and times:

08:00:00 - 15:59:59	Day Shift
16:00:00 - 23:59:59	Evening Shift
00:00:00 - 07:59:59	Night Shift
08:00:00 - 19:59:59	Weekend-Days
20:00:00 - 07:59:59	Weekend-Nights