上班時間總計 扣除休息時間 (15421)

B3=TEXT(SUMPRODUCT(FREQUENCY(ROW(INDIRECT(LEFT(B2,5)*1440+1&":"&RIGHT(B2,5)*1440)),{48,71,80,105,108}*10)*MOD(ROW($2:$7),2))/1440,"H:MM")