白天 晚上 各佔幾分 (14417)

D2:E9=SUMPRODUCT(FREQUENCY(ROW(INDIRECT(ROUND($B2*1440,)+1&":"&ROUND(($C2+($C2-$B2<0))*1440,))),{480,1440})*IF($B$1=B$1,{0;1;0},{1;0;1}))

F2:F9=(20*D2+30*E2)/60

G2:G9=SUM(FREQUENCY(ROW(INDIRECT(ROUND($B2*1440,)+1&":"&ROUND(($C2+($C2-$B2<0))*1440,))),{480,1440})*{3;2;3})/6