Dear All,
i would like to know if there is a way to sum a time interval like below:
Source:
| a | 03:40:16 |
| a | 01:01:10 |
| b | 10:54:59 |
Out:
| a | 04:41:26 |
| b | 10:54:59 |
Thanks in advance for you support.
AB
Hi alvabress,
You can calculate difference to a fixed date&time with a Date&Time Difference node (using 00:00:00 time and having chosen a granularity you need. e.g. seconds) and then aggregate the time difference with a Group By node using your category column as a group column.
Best,
Anna