Stopwatch data to be added to start time

KNIME Analytics Platform
#1

Hi there,

I have stopwatch data spanning for more than a day and I’d like to add it to a start date. As I have hour figures over 24, the “String to date and time” node refuses to convert it: “Execute failed: Failed to parse date in row ‘RowXXX’: Text ‘24:00:01’ could not be parsed: Invalid value for HourOfDay (valid values 0 - 23): 24”

Could you advise?

Thanks a lot,
ribizli

#2

I managed to split the timer info into hh mm ss columns using the cell splitter, then convert the strings to numbers and calculate the duration (in seconds) using the Math formula node. Then I could shift the original start date by the calculated seconds using the Date and Time shift node.

1 Like
#3

Nice workaround! Thanks for posting your solution :+1:

1 Like
#4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.