Time between events

[Rudi Groenewald]

Hi all,

I have got the following data in a report which I have created (just to show
you clearly what my main report and data looks like)

In my next report, I would have to show, how many minutes was spent on Slag,
how many on basket, and how many delay and so on.

How would my query look like if I had to calculate it with the following
data? My coloumn names from left to right :

RECEIVED , STATUSTEXT, SPEED, PLACE, DIRECTION.

Anyone know? Thanks
R

11:05 AM Delay 10 LHF Area S
11:06 AM Basket 11 LHF Area SW
11:07 AM Basket 0 LID S
11:08 AM Basket 10 LID SW
11:08 AM Delay 3 LID SW
11:09 AM Delay 3 Conarc2 E
11:10 AM Slag 0 Conarc1 SW
11:11 AM Slag 3 Conarc1 SW
11:12 AM Slag 0 LID S
11:13 AM Slag 8 LID S
11:13 AM Delay 5 LID S
11:14 AM Slag 0 LID S
11:15 AM Slag 5 LID SW
11:16 AM Slag 7 Conarc2 E
11:16 AM Delay 0 Conarc2 E
11:17 AM Delay 0 Conarc1 N
11:18 AM Delay 0 LID S
11:19 AM Slag 0 LID S
11:20 AM Slag 6 LHF Area SW
11:21 AM Slag 6 Total NW
11:22 AM Slag 7 Total S
11:23 AM Slag 8 Wash Bay E
11:24 AM Slag 7 Wash Bay S
11:25 AM Slag 0 Wash Bay S
11:26 AM Slag 0 Wash Bay S
11:27 AM Slag 5 Wash Bay S
11:28 AM Slag 0 Wash Bay S
11:29 AM Slag 3 Wash Bay S
11:30 AM Slag 7 Wash Bay S
11:31 AM Slag 11 Total S
11:32 AM Slag 10 LHF Area S
11:33 AM Slag 7 LID SW
11:34 AM Slag 3 LID SW
11:34 AM Delay 0 LID SW
11:35 AM Delay 1 LID SW
11:36 AM Delay 0 LID S
11:37 AM Delay 0 LID S
11:38 AM Delay 0 LHF Area W
11:39 AM Delay;Ignition off 0 LID S
11:53 AM 1st Startup 0 LHF Area W
11:54 AM Delay 5 LID SE
11:55 AM Delay 0 Conarc1 SW
11:56 AM Delay 0 Conarc1 SW
11:57 AM Delay 0 Conarc1 SW
11:58 AM Delay 0 Conarc1 SW
11:59 AM Delay 0 Conarc1 SW
12:00 PM Delay 0 Conarc1 SW
12:01 PM Delay 0 Conarc1 SW
12:01 PM Slag 0 Conarc1 SW
12:02 PM GPS unlocked 0 Conarc1 SW
12:02 PM Excess Idle 5 LID E
12:03 PM Slag 0 LID S
12:04 PM Delay 4 LID S
12:05 PM Slag 0 LID SW
12:06 PM Slag 5 LID S
12:07 PM Slag 6 LID NE
12:08 PM GPS unlocked 0 LID NE
12:08 PM Delay 0 LID NE
12:09 PM Delay 0 LID NW
12:09 PM Delay;Ignition off 0 LID NW
12:25 PM 1st Startup 0 Conarc2 S
12:26 PM Delay 0 Conarc2 SW
12:27 PM Slag 5 Conarc2 SW
12:27 PM Slag 1 Conarc2 S
12:28 PM Delay 0 Conarc2 S
12:29 PM Delay 11 LID SW
12:30 PM Basket 0 LID SW
12:31 PM Basket 11 LID N
12:32 PM Basket 3 Conarc2 E
12:32 PM Delay 0 Conarc2 E
12:33 PM Delay 11 LID SW
12:33 PM Basket 0 LID W
12:35 PM Basket 10 LID NW
12:35 PM Basket 5 Conarc1 W
12:36 PM Basket 0 Conarc1 W
12:37 PM Delay 0 Conarc1 SW
12:38 PM Delay 0 Conarc2 S
12:39 PM Delay;Ignition off 0 Conarc2 S
12:51 PM 1st Startup 0 Conarc2 SW
12:52 PM Delay 0 Conarc2 SW
12:53 PM Delay 0 Conarc2 S
12:54 PM Slag 0 Conarc2 S
12:55 PM Slag 5 Conarc2 SE
12:56 PM Slag 0 LID S
12:57 PM Delay 7 LID S
12:57 PM Slag 0 LID SW
12:58 PM Slag 12 LID W
12:59 PM Slag 9 Conarc1 W
01:00 PM Delay 0 Conarc1 W
01:01 PM Delay 3 LID S
01:02 PM Slag 0 LID S
01:03 PM Slag 6 LHF Area S
01:04 PM Slag 6 Total NW
01:05 PM Slag 5 Total S
01:06 PM Slag 6 Wash Bay N
01:07 PM Slag 5 Wash Bay SE
01:08 PM Delay 4 Wash Bay S
01:09 PM Delay 0 Wash Bay S
01:09 PM Slag 0 Wash Bay S
01:10 PM Slag 0 Wash Bay S
01:11 PM Slag 0 Wash Bay S
01:12 PM Slag 0 Wash Bay S
01:13 PM Slag 8 Wash Bay S
01:14 PM Slag 11 Wash Bay N
01:15 PM Slag 10 Total N
01:16 PM Slag 10 LID N
01:17 PM Slag 0 Conarc2 E
01:18 PM Slag 0 Conarc2 E
01:19 PM Slag 11 Conarc2 SE

 

[Rick B]

Please do not post duplicate messages. This has been addressed in another
group.