I have a spreadsheet with a column that includes a time value. I've successfully used the below formula for a straight 12-8, 8-4 and 4-12 shift but I also need to calculate a crossover shift... 11pm - 7am = T1, 7am - 3pm = T2, 3pm - 11pm = T3, changing the timevalues accordingly in the below formula isn't returning the correct information. Any suggestions?

=IF(AND(E11>=TIMEVALUE("24:00:00"))*(E11<=TIMEVALU E("8:00:00")),"T1",IF(AND(E11>=TIMEVALUE("8:00:00" ))*(E11<=TIMEVALUE("16:00:00")),"T2",IF(AND(E11>=T IMEVALUE("16:00:00"))*(E11<=TIMEVALUE("24:00:00")) ,"NA","T3")))

If E11 is 11:00 PM, what determines it to be one shift or the other?