✔ 最佳答案
提供範例檔, 較易取得協助 ~
http://www.funp.net/
2009-02-20 20:29:12 補充:
設日期時間資料在A欄,
利用公式做輔助欄位, 對輔助欄位篩選即可 ~
尾秒是5的篩選 =IF(RIGHT(SECOND($A2),1)="5",1,"")
尾分是5的篩選 =IF(RIGHT(MINUTE($A2),1)="5",1,"")
尾時是5的篩選 =IF(RIGHT(HOUR($A2),1)="5",1,"")
尾日是5的篩選 =IF(RIGHT(DAY($A2),1)="5",1,"")
尾月是5的篩選 =IF(RIGHT(MONTH($A2),1)="5",1,"")
尾年是5的篩選 =IF(RIGHT(YEAR($A2),1)="5",1,"")
參考檔案 :
http://www.FunP.Net/519226
有疑問請提出討論 ~