Manipulating and sorting time data

Hi there,

I have a data set containing downtime of a production line. The time period may overlap with another and hence only the longest period should be used.

I would need to upload back this data in the system in form of production uptime from 00:00:00 to 24:00:00 with the downtime periods in its interval.

I can’t figure out how to manipulate and sort the data with KNIME basic nodes as I have restrictions in using community nodes. Help is much appreciated.

Thank you for your time!

Data Sample.xlsx