上班時間計算 晚到早退扣除 (15261)

C2=TEXT(SUM(MID(B2,{1,7,13,19},5)*{-1,1,-1,1}),"H:MM")

D2=TEXT(SUM(SMALL(IF({1,0},MID(B2,{7;19},5)*1,{12;18}/24),{1,3})-SMALL(IF({1,0},MID(B2,{1;13},5)*1,{8;14}/24),{2,4})),"H:MM")