I changed how Crystal Report did the date and time format to include a space before am/pm so excel actually thinks it is date/time

I have a years worth of data to crunch and was trying to determine what days/time of day had the most call activity

Bill