cell filtering

[reipanik]

guys i need some advice on this

lets say i ahve 3 columns, in the first column, the input is in this format, 12/01/11 7:00 PM, in the second column, i would jsut like to filter 12/01/11, meaning just the date, and then on the 3rd column, just filter AM or PM. i do this because i filter date inputs, and then would have to only display and classify data by date, and then if they are morning or afternonn inputs


thx

[benishiryo]

hi reipanik. 2 methods each for each column. 2nd column:
=INT(A1)
format cells to desired format (dd/mm/yy)
or
=TEXT(A1,"dd/mm/yy")+0

column 3:
=IF(MOD(A1,1)>=0.5,"PM","AM")
or
=TEXT(A2,"AM/PM")

[reipanik]

will this function work for an excel 2003

[benishiryo]

yes it should

[reipanik]

thx alot!!!!!!