Variance between date/time? Crystal 8.5 1

[mdieckman]

Lets say that I have a list of times in a report like so:

11/6/06 9:30 am
11/6/06 9:45 am
11/6/06 10:15 am
11/6/06 12:00 pm

Is it possible to tell the variance (difference) between the dates and times from the field and the record below it?

For example, is there a calculation that does this for me?

11/6/06 9:30 am
11/6/06 9:45 am 15 minutes
11/6/06 10:15 am 30 minutes
11/6/06 12:00 pm 105 minutes

 

[lbass]

Try:

datediff("n",previous({table.datetime}),{table.datetime})

-LB

 

[mdieckman]

Wow, thanks for the speedy reply. Worked like a charm!