Getting interval duration

[martinqlik]

​Hello all,

I need to get the execution time btw several actions.

For example, the tasks starts as 'Aberto', then it goes to 'Aguarda Informacao PATS', and etc, until get into 'Recebido' which is the last status.

I attached a qvw with these informations, including the field execution time that needs to be calculated.

Does anybody knows how to make this?

Thank you,

[ahaahaaha]

Hi Martin,

If I correctly understood you, as an variant in the attached file.

Regards,

Andrey

[antoniotiman]

Hi Martin,

maybe

Interval(Max(TOTAL <ATIVIDADE> DATA_ALTERACAO)-Min(TOTAL <ATIVIDADE> DATA_ALTERACAO),'hh:mm:ss')

Regards,

Antonio