I am trying to calculate the running sum of the time difference and group it by date of the equipment used.
sample table:
ID Date In Out
1 15Oct10 10:15 11:05
2 15Oct10 11:45 12:05
3 17Oct10 12:45 13:00
4 19Oct10 2:50 3:00
5 20Oct10 23:05 2:05
Sample query:
ID Date...