算一產品工時 (13123)

D2=TEXT((INT(C2-B2)*660+SUM(FREQUENCY(ROW(INDIRECT(ROUND(MOD(B2,1)*1440,)+1&":"&ROUND((MOD(C2,1)+(MOD(C2,1)<MOD(B2,1)))*1440,))),{480,690,720,1050,1080,1320,1920,2130,2160,2520})*{0;1;0;1;0;1;0;1;0;1;0}))/1440,"[HH]:MM")