Hello,

I am trying to do an analysis on 4 spreadsheets, each with approximately 4500 cells.

Each vertical cell represents a patient visit to a hospital. There is a timestamp, then a bunch of other metrics that I will be comparing. I want to sort the 4500 visits by time and date. This is how the timestamp of their arrival shows up:

Jul 02 2012 10:25 AM
^A single cell contains both the date and time next to each other.

I want to first separate all visits by time of day. I want to make one group that checked in between 10a and 10p and another for 10p-10a. Then I want to sort both groups in chronological order by date (i.e. starting with 2011 and ending in May 2013).

For one, I'm thrown off because the time and date are next to each other in the same cell.

Can this be done? Calling Excel gurus.

TIA.