Icon

hhh mm ss Durations

Sample Datasplit into hour minute and secondsloop through the hhh:mm:sscolumnsdefine output column nameout_col_nameconvert each to intcalc h m s valuein secondsremove allthe "intermmediate" columnsrinse and repeatloop through the hhh:mm:sscolumnssplit into hour minute and secondscreate a duration stringas9H 99m 99sConvert duration stringsto actualduration columnsrinse and repeatdefine output column nameout_col_nameremove allthe "intermmediate" columnssample calculationA / BTable Creator Regex Split Column ListLoop Start VariableExpressions String To Number Math Formula Column Filter Loop End (ColumnAppend) Column ListLoop Start Regex Split String Manipulation String to Duration Loop End (ColumnAppend) VariableExpressions Column Filter Math Formula Sample Datasplit into hour minute and secondsloop through the hhh:mm:sscolumnsdefine output column nameout_col_nameconvert each to intcalc h m s valuein secondsremove allthe "intermmediate" columnsrinse and repeatloop through the hhh:mm:sscolumnssplit into hour minute and secondscreate a duration stringas9H 99m 99sConvert duration stringsto actualduration columnsrinse and repeatdefine output column nameout_col_nameremove allthe "intermmediate" columnssample calculationA / BTable Creator Regex Split Column ListLoop Start VariableExpressions String To Number Math Formula Column Filter Loop End (ColumnAppend) Column ListLoop Start Regex Split String Manipulation String to Duration Loop End (ColumnAppend) VariableExpressions Column Filter Math Formula

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: @takbb Brian Bates
Created at: 2021-07-13
On NodePit since: 2022-02-06
Last update: 2024-05-01
Created with KNIME version: v4.3.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!