计算总金额 分二時段 (9415)

以分计算 D2=SUM(FREQUENCY(ROW(INDIRECT(ROUND(MOD(B2,1)*1440,)+1&":"&ROUND(MOD(C2,1)*1440,))),1080)/60*{20;30})

另解{=ROUND(SUM(TEXT(MOD(B2:C2,1)-{0;0.75},"[<]!0")*{-1,1}*{20;10})*24,)

另解{=SUM(ABS(B2:C2-MEDIAN(B2:C2,INT(B2)+3/4))*{480,720})

另解{=(C2-B2)*480+TEXT(MOD(C2,1)-MEDIAN(MOD(B2:C2,1),3/4),"[<]0")*240