How to Calculate Start Time -End Time for each Pallet ID

[rustyfishbones]

Hi All,

Please see the attached, I have a field called PalletNumber and I want to calculate how much time it took to pick the cases for each pallet ID

[gopalopsharma · Accepted solution]

Hello Alan,

Follow the steps below:

1. Add a straight table

2. Add PalleteNumber as dimension

3. Write the expression below:

minute(num(max([End Time]))-num(min([Start Time])))

This will give results in minutes

If you wish, you can create two expressions for Max([Time Period]) and Min([Time Period]) and then in third you just need to write column(2)-column(1)...

Hope this helps.

[rustyfishbones]

Thanks Gopal