Determine which shift took a sample

[atalooseend]

Hi,

I need to determine which shift took a sample based on the date in column A (starting at A2) and the time in column B (starting on B2).

There are 4 shifts, RED, GREEN, BLUE YELLOW. They work 2 days from 6AM to 6PM then 2 nights from 6PM to 6AM then have 4 days off.

The start date for the date/time for the data is 11/10/14 and 22:00 when GREEN shift were working. After GREEN finished, BLUE worked the day shift and RED worked the night shift, then YELLOW worked the day shift and BLUE the night shift, GREEN day, YELLOW night, RED day, GREEN night etc.

Thanks very much for the help.