Multiple columns of time into Seconds

[ngumpena]

Hi,

I’m having multiple “Local time (hh:mm:ss)” format based fields and I would like to convert all of them into seconds.

Any idea to perform all at once using loop functionality?

Regards,
Neelima

[bruno29a]

Hi @ngumpena , you can use the Date&Time Difference node.

Just configure it to find the difference from 00:00:00 and use Seconds as Granularity:

Since your second column is 00:00:00, you will get the results as negative.

Just apply the abs() function from the Math Formula node:

Results:

That’s how the workflow looks like:

EDIT: You do NOT need any loop. Knime will apply this to each row automatically for you

[ipazin]

Hello @ngumpena,

if you are doing this for multiple columns one way to do it is indeed to use loop with @bruno29a’s logic inside it. See here an example of such a loop:

Looping over all columns and manipulation of each – christian.birkhold

Another way is unpivot, apply logic, pivot approach which is faster as no loop is needed. See here:

Replace Values over Multiple Columns – ipazin

Br,
Ivan