加班時數計算 (14239)

E2=D2-C2

F2=INT(IF((B2=B$7)+(B2=B$8),E2-(D2-"13:30">0)*1.5/24,MAX(,D2-"18:00"))*48)*0.5

G2=MID("-ABC",LOOKUP(F2,IF((B2=B$7)+(B2=B$8),{0,0.1,2.1,8.1},{0,0.1,2.1}),{1,2,3,4}),1)