Traditional Culture Encyclopedia - The 24 Solar Terms - In EXCELE, how to write a judgment sentence, judge that 7:45:03 belongs to peak time, normal time and low time.
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:
- Related articles
- What is the power supply of ECU-powered sensor and throttle position sensor?
- Summer SMS copywriting Summer WeChat copywriting sentence
- Twelve solar terms theme painting
- What is the reason why Orie is trembling?
- How to solve excessive valve clearance?
- Write poems about the heat in summer.
- What are the rules for finger scratching?
- Greetings from greeting cards for the twenty-four solar terms.
- Ten creative activities with the theme of May Day Labor Day.
- Key points of solar terms health care