Convert duration to HH:MM:SS

[WesselHL]

Hi everyone,

I am trying to convert 3 columns that have the durations in seconds to the format hh:mm:ss

For example the first row in the first column (5 seconds call duration) should look like this: 00:00:05

Unfortunately I am not able to share any more of the data as it contains confidential information.

Any help would be appreciated.

[gonhaddock]

Hello @WesselHL , and welcome to the KNIME community.

You can test with ‘Column Expressions’ node (Type == Local Time / String):

hours = padLeft(floor(column("time_sec")/3600), 2, "0")
minutes = padLeft(floor(mod(column("time_sec")/3600, 1)*60), 2, "0")
seconds = padLeft(mod(column("time_sec"),60), 2, "0")

join(
    hours
    , ":"
    , minutes
    , ":"
    , seconds
)

BR

[WesselHL]

Hi @gonhaddock ,

This worked thank you