E3:E14{=INDEX(A:A,RIGHT(SMALL(IF(C$3:C$23=C$3,MATCH(A$3:A$23,A:A,)/1%+ROW($3:$23),9999),ROW(A1)),2))&""
F3:G14=IF(E3="","",IFERROR(INDEX($B:$B,SMALL(IF($A$3:$A$23=$E3,ROW($3:$23)),COUNTIF($E$3:$E3,$E3)*2-2+COLUMN(A1))),""))
H3:H14=IF(E3="","",IFERROR(ROUND((G3-F3)*1440,),"尚未停"))
留言
張貼留言