Integrating Work Hours and Holiday Schemas for Accurate Timesheet Management

The Work Hours Schema plays a key role in standardizing and automating the management of employee working time within the organization.

The primary purpose of the Work Hours Schema is to define the expected daily working hours for each employee. When combined with the holiday schema, it enables precise calculation of the required work hours a user must log for each day of the week. This calculation supports accurate time tracking and ensures compliance with organizational and legal working time policies. The computed required hours are displayed as tooltips on the corresponding timesheet cells. If the required hours for a day are zero (e.g., due to a holiday), the cell is highlighted in green to indicate that the work hour obligation for that day has been fulfilled.

• Monday to Friday: 8 hours per day required

• Saturday and Sunday: 0 hours (weekend)

Holiday Schema:

• Monday, November 10, 2025: Whit Monday (Public Holiday)

Open

Timesheet Behavior:

• Cells for days with required work hours display tooltips on hover showing detailed info such as:

  • Hours logged

  • Required hours (from Work Hours Schema)

  • Holiday information

  • Applicable schemas (e.g., Default Work Hours Schema, German Holiday Schema)

Open

The calendar view for November 2025 displays Jessie Lauren’s logged work hours alongside the required daily hours defined by the Work Hours Schema and adjusted by the Holiday Schema.

Overview:

• Total logged hours: 81 hours 55 minutes

• Total required hours: 152 hours (Since November 10, 2025 is holiday, 8 hours are deducted from the 160 hours)

• Tooltip indicates “Default work hours schema / German Holiday Schema” in use.