最早與最晚的时间 (12326)

C2:C3{=INDEX(A:A,RIGHT(INDEX(PERCENTILE((MID(A$2:A$11,FIND(" ",A$2:A$11)-4,4)&"/"&LEFT(A$2:A$11,FIND(" ",A$2:A$11)-6))*10^8+RIGHT(A$2:A$11,8)*144000+ROW($2:$11),{0,1}),ROW(A1)),2))



留言