How to calculate the time from each End Time to each Start Time

[rustyfishbones]

Hi All,

I have a Start Time and an End Time field in my Table.

I can capture the total time spent doing a task, as you see below I have a Picking Time of 17 seconds

However I am trying to calculate the travelling time, which is the time lapsed between the End Time and the next Start Time

the result in the below scenario for Travelling Time would be 13 seconds

[MK_QSL · Accepted solution]

Something like this?

[rustyfishbones]

Exactly like that,

Thanks Manish

[rustyfishbones]

Manish,

Would you recommend I do something similar in the Script for Picking Time?

Regards

Alan

[MK_QSL]

email me your query or create an another thread.

Would love to help you.

[rustyfishbones]

I will get some sample data together as I have a few questions

Maybe it's better to create a new thread for each question

As that will help others too! and I can always look back if i ever forget