Sort Time

[Zorro9758]

I have a multiple cells containing a Date and Time.

11/19/12 4:54 AM
11/19/12 5:03 AM
11/19/12 12:04 PM
11/19/12 12:07 PM
11/19/12 12:07 PM
11/20/12 6:32 AM
11/20/12 6:33 AM
11/20/12 6:35 AM
11/20/12 11:46 PM
11/20/12 11:47 PM
11/20/12 11:47 PM
11/20/12 11:48 PM

How can able to sort by time only

Thanks

[benishiryo]

hi Zorro9758, welcome to the forum. assuming data starts from A2, you can do a formula beside it like this:
=MOD(A2,1)

This will give you just the time. then sort according to this column.

[Zorro9758]

Great! that works for me

Thank You!!