I have been trying to create a if statement in excel without using a macro. I need the statement to show which shift our data is showing, the data is shown as "1/5/2015 00:00:00". I need the if statement to break it down into 3 shifts going from 23:00:00 to 06:59:00 and so on for the 2 other...