Calculating a time difference between two records (same field) 1

[ramc2000]

Hi, I am trying to calculate the time elapsed between two events. I have a field in my table that gives me the time at which some event was logged. What I want is to display the time elapsed between that event and the previous one:


Event, Date/Time logged, Time elapsed.

1 11:39 39 minutes
2 11:00 10 minutes
3 10:50 5 minutes
4 10:45

 

[Pasi12]

try this:
datediff("d",{table.field}, previous({table.field}))