Use a formula to create time bands for your Crystal Report.

One of the students on our course was working with call centre data. They wanted to summarize the data into 15 minute intervals. You can do this with the following formula:

Minute({timefield}) – Remainder (Minute({timefield}),15)

This will return values of 0, 15, 30 and 45. If you require other intervals, replace the 15 in the above formula. Combine this with additional formulas to extract the date and the hour of the call, and useful performance statistics can be created.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.