=IF(OR(HOUR(B3)={9,10,11,12,13,14,15,16,17,18}),"早班","晚班") 转载于:https://www.cnblogs.com/xiaomifeng/p/5850041.html