Hi experts!  I am a newbie on Crystal Reports and our business just started using crystal reports and I have been thrown in learning on my own.  I am trying to do a duration formula.  However, the fields that I have are Report_Events.Timestamp (Date Time that event starts and stops).  Also, I have Reports_Events.Type (Has the data "Start", "Stop".  So I need to create a report for the stop datetime - start datetime duration in seconds but can I do this with there not being a StartTimestamp and a StopTimestamp?

Yes I sorted by timestamp and there is a corresponding start for every stop and a stop for every start.

Those formulas worked great!  Another question the duration formula shows a 0 for the stop time and shows the duration on the stop time.  How do I make it so it will just show the duration on the stop time?

Right-click on the duration object in the report and select "Format...".  Go to the first tab and click on the button to the right of "Suppress" (DO NOT check the checkbox!) and enter something like the following:

{MyTable.Type} = 'Start'