excel if判断时间段早晚班

=IF(OR(HOUR(B3)={9,10,11,12,13,14,15,16,17,18}),"早班","晚班")

 

posted @ 2016-09-07 16:46  KSnow  阅读(7076)  评论(0)  编辑  收藏  举报