Icon

Idle Time Calculator

This workflow is a modification of https://hub.knime.com/hanss/spaces/Public/latest/forum_flows/Calculate%20working%20daysIt takes a table with at two columns(start and end date), as well as a table with the number of idlehours per week day as inputs and calculates the total number of idle hours between those twodates. extract min & maxdates for entire date rangecreate calenderday of weeksum idle timesAdd start dateAdd end dateStart and End DatesNode 81Node 82Idle time per week dayNode 84Node 86Node 87Node 88Node 89Node 90 GroupBy Create Date&TimeRange Extract Date&TimeFields Rule-basedRow Filter GroupBy ConstantValue Column ConstantValue Column Loop End Table Creator Table Row ToVariable Loop Start Table Rowto Variable Table Creator String to Duration Joiner ExtractDuration Fields Math Formula Column Filter Column Resorter This workflow is a modification of https://hub.knime.com/hanss/spaces/Public/latest/forum_flows/Calculate%20working%20daysIt takes a table with at two columns(start and end date), as well as a table with the number of idlehours per week day as inputs and calculates the total number of idle hours between those twodates. extract min & maxdates for entire date rangecreate calenderday of weeksum idle timesAdd start dateAdd end dateStart and End DatesNode 81Node 82Idle time per week dayNode 84Node 86Node 87Node 88Node 89Node 90GroupBy Create Date&TimeRange Extract Date&TimeFields Rule-basedRow Filter GroupBy ConstantValue Column ConstantValue Column Loop End Table Creator Table Row ToVariable Loop Start Table Rowto Variable Table Creator String to Duration Joiner ExtractDuration Fields Math Formula Column Filter Column Resorter

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: Loïc
Created at: 2021-02-08
On NodePit since: 2021-02-08
Last update: 2024-04-26
Created with KNIME version: v4.3.1

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

Try NodePit Runner!