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.
Thank you.
