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