What do the columns in Department Statistics mean? How are the figures calculated?
Employee Time Tracking
Project Time Tracking
Leave Management
Additionally, this article only applies to "Managers"
department-statistics

The Department Statistics report, from within the Reports menu, is similar to the Timesheet Report and Employee Statistics, but collectively displays data for all employees within a department.

It is recommended that you are familiar with the Timesheet Report before continuing with this article.

NWH, TWH and B

  • NWH (Normal Working Hours): The amount of hours that should be recorded on this day as defined by the work schedule.
  • TWH (Target Working Hours): The Normal Working Hours for that day, with consideration to other factors which may affect the required working time. For example, if a particular day was a public holiday, the Target Working Hours for that day would be reduced to 0 as the workplace was closed. Alternatively, if the employee had used 2 hours of compensation time that morning, then the Normal Working Hours of 8 would be reduce to 6 in the Target Working Hours.
  • B (Breaks): The total duration of breaks.

WH, OT50, OT100 and BO

WH shows the amount of Working Hours that were recorded on that particular day. This is the total duration of timestamps for that day (excluding non-productive time, such as breaks).
OT50 and OT100 represent overtime that has been earned with 50% and 100% additional premium rates. When this overtime can be earned is defined by the work schedule.

The BO column is the total amount of bonus premium that was earned. For example, a single hour within OT50 and one more hour within OT100 would total 1.5 hours of bonus overtime. This would equate to 1.5 hours in addition to the standard working time.

If you have different rates of overtime to the defaults provided, or your employees earn overtime in other circumstances, then please get in touch via
If your employees do not earn overtime, then you can remove these columns from view via the dropdown menu in the top-right hand corner of the display.

If the working model defines different rates of pay for overtime, these will appear in the columns OT10 (10% Premium), OT25 (25% Premium) and, as in this example, OT50 (50% Premium.) The sum of overtime with the premium can be seen under BO.

TWT, PNT, TPT and WT%

TWT is the total amount of actual hours worked.
PNT (Paid Non-Working Time) represents any time that the employee is entitled to be paid for, yet was not working time. This includes public holidays, sickness and annual leave.

By default, other leave types contribute towards Paid Non-Working Time. These include maternity leave and training courses, among others.

If you require other leave types which are not included, or you require leave types which do not count as Paid Non-Working Time, then send us an e-mail at

TPT displays the Total Paid Time for that day. This is a sum of the Working Hours and any Paid Non-Working Time.

WT% shows the percentage of Total Paid Time that was actual working time.

DB and TB

The DB column represents the Daily Balance of hours. This is the difference between the Total Paid Time and the Target Working Hours. For example, if the target hours for a day amounted to 8, and the employee worked 9.5 hours, then the Daily Balance would have a value of 1.5

The TB is the Total Balance, or the running total of an employee’s Daily Balance. This shows an overall plus or minus amount of hours to that date.

OP and CT

OP refers to the Overtime Payout. This is a column where a manager can input the amount of hours that the employee has been paid for. Any figure entered here will reduce the Total Balance by that amount too.

CT refers to Compensation Time, or additional hours that the employee has used to have time off from the workplace. Any figure entered here will reduce the Total Balance by that amount too.

The ACT and RCT columns show any other upcoming comp time requests which have been approved or are awaiting approval

LD, PH, SA and OL

The following sections only concerns those users who are also using Leave Management
  • LD (Leave Day): Whether annual leave was consumed on that day. A figure of 1 represents an entire working day. This will reduce the Target Working Hours accordingly.
  • PH (Public Holiday): Whether a public holiday occurred on that day. A figure of 1 represents an entire working day. This will reduce the Target Working Hours accordingly.
  • SA (Sickness Absence): Whether the employee was absent due to sickness on that day. A figure of 1 represents an entire working day. This will reduce the Target Working Hours accordingly.
  • OL (Other Leave): Whether the employee was absent for another reason on that day. A figure of 1 represents an entire working day. This will reduce the Target Working Hours accordingly. The type of absence can be specified in the next column
The ALD and RLD columns show any other upcoming leave requests which have been approved or are awaiting approval

Didn't find what you were looking for?

Germany 0800 - 240 40 50
Austria 0800 - 240 40 50
Switzerland 0800 - 240 40 5
EU-International +43 (0) 316 587142
Switzerland 0800 - 240 40 5
EU-International +43 (0) 316 587142