Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

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

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

2014-02-18_1412.png

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Something like this?

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Something like this?

rustyfishbones
Master II
Master II
Author

Exactly like that,

Thanks Manish

rustyfishbones
Master II
Master II
Author

Manish,

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

Regards

Alan

MK_QSL
MVP
MVP

email me your query or create an another thread.

Would love to help you.

rustyfishbones
Master II
Master II
Author

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