Hi,
I`m trying to calculate the duration of a column (inputTime) but not sure how could I limit it to calculate all entries that are less than 15min apart.
example: In the below column, there has been a gap of more than 15min between entries, what I would like to achieve is that when calculating the whole duration, the expression can identify the gap and calculate only entries with less then 15min.
Could anyone shed a light on this?
Many thanks
| 10/03/2022 00:05:45 |
| 10/03/2022 00:06:26 |
| 10/03/2022 00:06:39 |
| 10/03/2022 00:11:16 |
| 10/03/2022 00:11:43 |
| 10/03/2022 00:13:52 |
| 10/03/2022 00:14:29 |
| 10/03/2022 13:16:36 |
| 10/03/2022 13:17:37 |
| 10/03/2022 13:17:56 |
| 10/03/2022 13:18:12 |
| 10/03/2022 13:18:38 |
| 10/03/2022 13:18:57 |
| 10/03/2022 13:19:28 |
| 10/03/2022 13:20:03 |
| 10/03/2022 13:20:11 |
LinkedIn
Twitter
