Calculating interval between different actions

[martinqlik]

Hello all,

I need to calculate the interval between different actions, for example.

Production1 starts at 8:00 pm

Production2 starts at 8:12 pm

Revision1 starts at 8:14 pm

etc...

The graphic must show total time and the interval between different steps as production1, production2, revision1 etc.

Does anybody know how to make this up?

Attaching a qvw with informations.

Thank you!

[Anil_Babu_Samineni · Accepted solution]

Don't create double post for single issue

Calculating interval between different topics

And, Answer for your question is Text object don't have capable for multiple values at a time. You can create straight / pivot table for the same. It should work. Still you want in text object then try like this

=Concat(Interval(End-Start, 'hh:mm:ss'),chr(10))