格式化 一小時分四格 區間顯色 (Format: four frames per hour, interval coloring) (11903)

格式化D2:AQ6=INDEX(FREQUENCY(MOD(COLUMN(A1)-1,4)/96+LOOKUP(1,$D$1:D$1),CEILING($B2:$C2-CHOOSE(COLUMN($A:$B),14,0)/1440,1/96)-1%%%),2)