Icon

12 hour to 24 hour times

Additional work required here for determining if first row is am or pm Sample dataConcatenate date and timestrings with a space betweenGet differencein minutes from previousrecordGet previousrecord datetimed/M/yyyy k:mm(k rather than h used as we need it to recognise 1-12 but we don't have an am/pm indicator)If difference from previous is negative, thenwe have moved to afternoon, so mark as 12 hoursto addGet DATEfrom previous rowIf the date haschanged from previous row, itis now morning,so mark as 0 hoursto addFor all the "missing" hoursto add, copy downfrom previous recordshift time forwardby "hours to add"tidy up Table Creator Column Aggregator Date&TimeDifference Lag Column String to Date&Time Rule Engine Lag Column Rule Engine Missing Value Date&Time Shift Column Filter Additional work required here for determining if first row is am or pm Sample dataConcatenate date and timestrings with a space betweenGet differencein minutes from previousrecordGet previousrecord datetimed/M/yyyy k:mm(k rather than h used as we need it to recognise 1-12 but we don't have an am/pm indicator)If difference from previous is negative, thenwe have moved to afternoon, so mark as 12 hoursto addGet DATEfrom previous rowIf the date haschanged from previous row, itis now morning,so mark as 0 hoursto addFor all the "missing" hoursto add, copy downfrom previous recordshift time forwardby "hours to add"tidy upTable Creator Column Aggregator Date&TimeDifference Lag Column String to Date&Time Rule Engine Lag Column Rule Engine Missing Value Date&Time Shift Column Filter

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-12
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!