Thanks much Lowell.
I thought about that on my way home. The TimeFromTo was from a view that cast the times as varchar and concatenated to a single string. Here is the actual data:
PtIDApptDateApptDateTimeFromTimeToActivity
14247/7/2014 0:0012/30/1899 9:00:00 AM12/30/1899 10:00:00 AMOpening Group
14247/7/2014 0:0012/30/1899 10:00:00 AM12/30/1899 11:00:00 AM1:1 ST Jerilyn
14247/7/2014 0:0012/30/1899 11:00:00 AM12/30/1899 12:00:00 PMConditioning Group
14247/7/2014 0:0012/30/1899 1:00:00 PM12/30/1899 2:00:00 PMMenu Planning Group
14247/7/2014 0:0012/30/1899 3:00:00 PM12/30/1899 4:00:00 PMLife 101 Group
14247/7/2014 0:0012/30/1899 4:15:00 PM12/30/1899 4:45:00 PMMedical Appt
14247/7/2014 0:0012/30/1899 5:00:00 PM12/30/1899 5:15:00 PMLaundry Day
Chris