判斷時間的區間 (12975)

B2=LOOKUP(A2*1440,{0,480,1201},{"N","D","N"})

另解=MID("DN",1+(ABS(A2-7/12)>1/4),1)

另解=CHAR(78-(MOD(A2-1/3,1)<=1/2)*10)

另解=IF(A2=MEDIAN(A2,"8:00","20:00"),"D","N")