Hello,
Is there any way to do the difference between 2 timestamps in seconds using a lead function in beast mode.
For example in below table take the first 2 rows 9:51:47 seconds subtracting with first row that is 9:51:14 seconds and output should be 33 seconds. The column is in String datatype.
Can I achieve this using beast mode or magic etl?
Wed | 22 Mar 2023 09:51:14 |
---|
Wed | 22 Mar 2023 09:51:47 |
Wed | 22 Mar 2023 09:59:55 |
Wed | 22 Mar 2023 10:06:16 |