Can anyone help me with how to do a set expression to calculate elapsed time, given this table? It can't be done in the load script, because i need to compute it ad hoc, based on user selections:
Log ID
Start Date Time
End Date Time
Affected ID
1
10/03/2022 8:00
10/03/2022 10:00
A
1
10/03/2022 8:00
10/03/2022 10:00
B
1
10/03/2022 8:00
10/03/2022 10:00
C
2
10/03/2022 9:00
10/03/2022 10:30
A
3
10/03/2022 14:00
10/03/2022 15:00
A
I am having trouble when Start and End times overlap.
My intended output for the Total Elapsed Time of Affected ID A = 210 mins.
