Hi all,
I have a problem with calculating the time difference between two date and times. I have tried to use the “string to Date/time” and “Date&Time difference”, but it wont work.
I have also tried to “manipulate” the date and time in my excel sheet before adding it in Knime, but nothing works.
I want to calculate the time between “Time 1 (visit)” and “time 2 (call cancel)”
After I get the result, i would also like to find out if theres a correlation between either “reason” or “size”. I was thinking about using the node “Linear Correlation”, is this a good method?
I have uploaded a selection of the data available to me, so you can see the data formation.
Thank you in advance.
KnimeForumData.xlsx (36.9 KB)