averaging with date and time

Guys, how do you calculate the average of hours in this column and keep the format in hours and minutes, I tried to do that but the average return I have is an integer.

image

hi @Moreiraxx , here’s my suggestion
immagine
Example
KNIME_project7.knwf (10.3 KB)

1 Like

@duristef
I do not understand , how did you configure that last node , could you explain how you did to return to the format of hours and seconds , after calculating the average ?

@Moreiraxx
I used a dedicated function to transform the mean (which is expressed in seconds) into a duration and I defined the column type as “Duration”

immagine

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.