Announcements
cancel
Showing results for
Did you mean:
Master II

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

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

1 Solution

Accepted Solutions
Creator

Hello Alan,

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.

2 Replies
Creator

Hello Alan,

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.

Master II
Author

Thanks Gopal

Community Browser