Next Max Time in second column

[Waqas ali]

dear all,

i have below timings in one column i want to see each next time with previous time in second column as start and end how to write a query?

CompletedDateTime

22-Nov-15 09:09:31

22-Nov-15 09:10:18

22-Nov-15 09:11:42

22-Nov-15 09:13:46

22-Nov-15 09:15:23

22-Nov-15 09:21:45

22-Nov-15 09:21:50

22-Nov-15 09:22:14

22-Nov-15 09:23:35

22-Nov-15 09:25:36

22-Nov-15 09:27:53

22-Nov-15 09:28:47

<colgroup><col></colgroup><tbody>
</tbody>

 

[alansidman]

Each Record has an ID

SELECT Sheet1.ID, Sheet1.StartTM, DLookUp("[StartTM]","Sheet1","[ID]=" & [ID]+1) AS NextStartTM, DateDiff("n",[NextStartTM],[StartTm]) AS [Difference in Minutes]
FROM Sheet1;