Hi, I have a field that contains string values in a format such as "00:00", what I need to do is pluck out selected sections and count them. Example there may be 15 different values between "00:00" and "00:59", Select expert only allows me to do this once. I need different counts for every hour of the day. I need to set up 24 formulas that range >"00:00" and <"00:59" then  > "01:00" and < "01:59" and so on. No matter what syntax I use i can't get it to work.

the Tablename is BK190707 and the field is PICKUPTIME

Clearly Crystal Reports is not able to count the number of grouped items in field, there must be better software on the market

Thanks Mate, I'll try anything