Difference in Hours/Minutes between 2 records

[DCecil07]

I am working on a report that has a timestamp per record. The report is broken out by 'Day' and has a detail below each. The detail is as follows...

Eval ID, Eval Description, Timestamp
107585, ACS Pend MTV, 7:50:24am
107999, ACS Pend MTV, 7:54:34am
108001, ACS Pend CI, 8:07:20am

I need to know the minutes that are between each record.

Can anyone help me as I need to get this completed at the end of the day today?

THANKS IN ADVANCE!!!

 

[pbaldy]

One method demonstrated here:

http://www.baldyweb.com/PrevValue.htm

 

[HAMMAMABUARQOUB]

if the EVALID is unique,, use datediff along with Dlast
how:
DateDiff(Dlast(cond EvalID1) and Dlast(condEvalID2)

i didn't try! but i think once something like that really worked nice!