Find the Difference Time

[Ribeiro]

The table below, I need to find and add up the difference.

Placa = 'LSP1241',Type(Chegado) ('11/01/2019 13:58:44', 'DD/MM/YYYY hh:mm:ss') - Placa = 'LSP1241',Type(Saindo) ('11/01/2019 14:32:53' ,'DD/MM/YYYY hh:mm:ss')

How would this set analysis

Placa	Date	Type
LSP1241	11/01/2019 13:58:44	Chegando
LSP1241	11/01/2019 14:32:53	Saindo
LVO7376	11/01/2019 15:26:28	Chegando
LVO7376	11/01/2019 15:51:20	Saindo
NHV8442	11/01/2019 12:31:31	Chegando
NHV8442	11/01/2019 13:44:56	Saindo
NIC6747	11/01/2019 10:20:43	Chegando
NIC6747	11/01/2019 10:27:35	Saindo

[Vegar · Accepted solution]

In a table containing the dimension Placa you could probably use this expression.

Only({<Type={'Saindo'}>}Date) - Only({<Type={'Chegando'}>}Date)