Convert date and time in serial number format to text format

I have a report which has listed a bunch of transactions by their date and time in a single cell in the following format "1/2/2013 9:08:00 AM".

I need to sort all of the transactions by the time of day regardless of the date. When I tried =right(A1, 9) it pulled out some of the serial numbers that the date is formatted in. Ist there a way to convert the serial number format to text format in order to pull the time out? Alternately, is there a way to sort by time only?

If you just want the time try this.

Formula:

Please Login or Register  to view this content.

=A1-Int(A1) will give you the time portion only. Format as Time in the new cell.

One way...

=MOD(A1,1)

Format as Time