Dorting Crystal report Times

[grierfield]

Example, I have a database that save time of occurances in the following way

11:20:00PM
8:20:00PM
9:20:00PM
8:20:00AM
8:10:00AM
12:20:00PM

I want to group these by AM and PM, how do I go about it?

 

[vidru]

Try creating a formula to distinguish the AMs from the PMs. Then, group on the formula:
[tt]
//@AmOrPm
If CTime({Table.Field}) < Time(12,00,00) Then
'AM'
Else
'PM'
[/tt]
This is version dependent (CTime function didn't exist until ver 8). Always a good idea to post your Crystal version at minimum. Other helpful info:
Database/Connectivity
Sample Data (which you supplied, but what's the datatype?)
Expected output

-dave