Elapsed Time Crystal Report

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.

E.G.
<------- 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
...

mcnAsked:
Who is Participating?
 
mlmccCommented:
Try this formula

If (PreviousIsNull({EventDateTiemField}) then
   0
else
   DateDiff('h',Previous({EventDateTiemField}),{EventDateTiemField})

mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
0
 
mcnAuthor Commented:
Glad you did!! Thanks you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.