-
Time difference between rows in same column
Is there any ways to count the time difference between each row using sql? In the example, I would like to get the difference between row 1 and 2, row 2 and 3, etc. I am thinking I am pretty much stuck doing this in excel. All the dates and times in this table are in the same column.
Any ideas would really be appreciated
time/date
1/3/05 8:00 AM
1/3/05 8:55 AM
1/3/05 9:00 AM
1/3/05 9:13 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|