In EXCELE, how to write a judgment sentence, judge that 7:45:03 belongs to peak time, normal time and low time.

= IF(OR(AND(a 1 & gt； =TIME(8，30，0)，a 1 & lt； Time (1 1, 30,0)) and (a1>; =TIME( 14，30，0)，a 1 & lt； Time (17,30,0)) and (a1>; =TIME( 19，30，0)，a 1 & lt； TIME(2 1, 0,0)), "rush hour", if (or (a1>; =TIME(23，0，0)，a 1 & lt； Time (7,0,0)), "Valley Time", "Peacetime")

According to the formula, there is nothing wrong: