How to use group by node to sum time

Hello, good morning.

I need to perform a process to calculate the total sum of duration of the video recording.
But when using the Groupby node, the sum option does not appear in the “Type-Based Aggregation” tab. I noticed that my Duration field format is correct (time). How can I add this range?

Site (Localidade)
Month (Mês)
Duration (“duração”, sum of hour recorded)


screen 3

Welcome to the forum @JeffsBr

I noticed that my Duration field format is correct (time). How can I add this range?

The format of that column is time, not a duration. Aggregating a clock position doesn’t really make sense.

For your task, you’ll need to extract the relevant hours/minutes/seconds using the Extract Date&Time Fields node and then do the math with a GroupBy node (or other node).

3 Likes