accumulation of time

[Fernando2000]

Hi, Search results than a query I get a list of events and hours , a Member which have, I wonder if anyone knows how to calculate Time Total acuumulate time in minutes, based on a schedule, for example from 13:00 to 15:00 not count. In this case the total would be 59 minutes. Thank you very much for the help.

03/03/2020 12:49
03/03/2020 12:53	4
03/03/2020 18:49
03/03/2020 18:52	3
03/03/2020 18:55	3
03/03/2020 19:06	11
03/03/2020 19:15	9
03/03/2020 19:25	10
03/03/2020 19:30	5
03.04.2020 8:02
04.03.2020 8:10	8
04.03.2020 8:15	6

[Brett_Bleess]

You would likely need to use set analysis for this and you may need to use AGGR too, here are a couple of Design Blog posts that may be helpful to get you on the right track there.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Hopefully this may get you on the right track, but you likely need to provide some further details on things to get further responses, as I was not quite sure of exactly what it is you are actually wanting to do, so apologies if I have missed the mark completely.

Regards,
Brett