Can someone please clue me in as to how to code a Crystal Report to determine the elapsed time between successive events. That is, I have a table whose records sequentially list event times. I need to difference them in the report to show the elapsed time.
<------- Table Fields/Data--->| Calc'dField
EventType EventDateTime ElapsedTime
A 1/1/07 12:55 PM
B 1/1/07 12:57 PM 00:02:00
C 1/2/07 01:03 AM 00:06:00