上班時間計算 扣除休息時間 (13795)

D2=SUMPRODUCT(FREQUENCY(ROW(INDIRECT(B2*1440+1&":"&(C2+(C2<B2))*1440)),{48,72,78,102,105,126,129,192}*10)*MOD(ROW($2:$10),2))/1440