A1=时间 B1=IF(AND(TIMEVALUE(TEXT(A1,"hh:mm:ss"))>=TIMEVALUE("08:30:00"),TIMEVALUE(TEXT(A1,"hh:mm:ss"))<=TIMEVALUE("17:00:00")),"白班","夜班")
=if(and(A1*24>=8.5,A1*24<=17),"白班","夜班")
