C2:
=IFERROR(YEAR(SMALL(IF(Q$1:Q$500=$B$2,R$1:R$500),ROW(A1))),"")
D2:
=IFERROR(MONTH(SMALL(IF(Q$1:Q$500=$B$2,R$1:R$500),ROW(A1))),"")
E2:
=IFERROR(DAY(SMALL(IF(Q$1:Q$500=$B$2,R$1:R$500),ROW(A1))),"")
F2:
=IFERROR(TEXT(SMALL(IF(Q$1:Q$500=$B$2,R$1:R$500),ROW(A1)),"hh:mm:ss"),"")
以上公式均要用Ctrl+Shift+Enter组合键完成输入，然后下拉填充。
