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?
Bookmarks