I want to know result between OUT/IN status duration time in minute.

My idea...

1. From the data source I use left join for test.

(But this solution very slow when query from MySQL database production)

2. Create cal field

"Min Time Diff"

{ FIXED [Time Stamp],[staff ID]:min([TimeStamp (20200121165700.csv1)])}

"Out time"

IF ISNULL([Min Time Diff]) THEN NOW() ELSE [Min Time Diff] END

"Total Time Out"

min(datediff('minute',[Time Stamp],[Out time]))

And this my result.

Please review & comment,

Anun P.