Icon

Business_​Hours_​and_​Days_​Calculator

Business Hours & Days Calculator

This workflow computes business hours and business days between timestamps, based on predefined working hours (e.g., 9 AM to 5:30 PM in below example) and excluding weekends and holidays.

It also accounts for scenarios where the task start time is later than the completion time, ensuring consistent and accurate calculations.

Calculate Business Days

Calculate Business Hours

Sample File
Excel Reader
Java Snippet
Inner business days
Java Snippet
Revise Start Date Time toalign with predefinedworking hours
Java Snippet
Revise End Date Time toalign with predefinedworking hours
Java Snippet
Column Filter
Date&Time to String
String to Number
Start & End DateBusiness Hours
Java Snippet
SumBusiness Hours
Expression

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: Lzy
Created at: 2025-09-11
On NodePit since: 2025-09-12
Last update: 2025-09-12
Created with KNIME version: v5.7.0

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

Try NodePit Runner!