Calculation of a duration between 2 Timestamps according to variation of a field

[kilouli]

Hi everyone,

so I have a table (See end of the message) that lists the movements of my pallets in the warehouse.
As you can see 1 pallet goes from 1 Location to another.
I want to be able to calculate the difference of time between 2 locations.
In this case I want to calculate the difference between the 1st time the pallet NTW33459 is registered in the location A999 and the moment it moves from this location to the other location A05882.
Is it possible to set a fornula that would take into account the location field and that would measure the difference between the 2 timestamps ?
Have a nice day , thx a lot
Alexandre
[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Location[/TD]
[TD]PalletID[/TD]
[/TR]
[TR]
[TD]8:00[/TD]
[TD]A999 [/TD]
[TD]NTW33459 [/TD]
[/TR]
[TR]
[TD]9:00[/TD]
[TD]A999 [/TD]
[TD]NTW33459 [/TD]
[/TR]
[TR]
[TD]10:00[/TD]
[TD]A999 [/TD]
[TD]NTW33459 [/TD]
[/TR]
[TR]
[TD]14:30[/TD]
[TD]A05882[/TD]
[TD]NTW33459 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

Will the times always be sorted from earliest to latest time?
What happens if a pallett is in location 1 at 23:00 and location 2 at 04:00am the next morning, ie different days?

Will there only ever be two locations for each pallett?
There wont be something like

8:00  A999   NTW33459
9:00  A999   NTW33459
10:00 A999   NTW33459
14:30 A05882 NTW33459
16:00 A12345 NTW33459
17:00 A67890 NTW33459

 

[kilouli]

Will the times always be sorted from earliest to latest time?
What happens if a pallett is in location 1 at 23:00 and location 2 at 04:00am the next morning, ie different days?

Will there only ever be two locations for each pallett?
There wont be something like

8:00  A999   NTW33459
9:00  A999   NTW33459
10:00 A999   NTW33459
14:30 A05882 NTW33459
16:00 A12345 NTW33459
17:00 A67890 NTW33459

Yes only two locations only.
For selecting the minimum time I thought A min() function could work ?