Excel. date and time = workshift X

I have a cell with date and time in the format: (dd-mm-yyyy tt:mm)
Based on this i'd like to extract the shift that made the data in my excel file.

Shift times are as follows
-Dayshift: 06:01-14:00 (Monday-Thursday) 06:00-13:20(Friday)
-Eveningshift: 14:01-22:50 (Monday-Thursday)
-Nightshift: 22:36-06:00 (Sunday evening - Monday morning) 22:51-06:00 (Monday-Friday)
-Weekendshift: 13:21-01:20 (Friday) 10:40-22:35 (Sunday)
Any event outside those shift should be returned as shift: Overtime

I've been @ this for hours with no result. Anyone up for the challenge? :)