Understanding attendance figures

Timesheets shows each employee's hours, overtime and attendance flags for the dates you pick. This article is for admins who manage employees' time logs: finding the days that need a look and checking why a figure is what it is.

The figures

Figures	How it worked out
Working hours	The hours the employee should work that day, set by their workgroup. 0 on a rest day, off day or holiday. Approved leave reduces it: full-day leave makes it 0, half-day leave halves it, and hourly leave takes off the leave hours, based on an 8-hour day.
Hours worked	Time between each clock-in and the clock-out after it, minus the break. Time before the scheduled start doesn't count
Break hours	Depends on the workgroup's Break calculation setting. 0 on a day with no worked time
Actual OT	Hours worked minus working hours, never below 0. Counted from clock records, even when no overtime was requested
Requested OT	Approved and pending overtime requests

Flags

Flag	When
Late	First clock-in after the start time. On a flexible schedule, that’s the end of the Start time window: with a window of 8:00 AM to 10:00 AM, a clock-in after 10:00 AM is late.
Left early	Last clock-out before the expected end
Insufficient hours	Hours worked less than working hours
No show	No clock-in and no clock-out on a working day
Missing clock-in	A clock-out with no clock-in before it
Missing clock-out	A clock-in with no clock-out after it

Each flag counts once per day at most.

Good to know

Each clock-in pairs with the next clock-out. A second clock-in before that clock-out is left out, and records without a pair don't add hours.
Clocking in early doesn't add hours. An employee who works 8:00 AM to 5:00 PM on a 9:00 AM to 6:00 PM schedule gets Insufficient hours 1h and Left early 1h.
With automatic break hour deduction, clocking out for lunch takes the break off twice. The time between a clock-out and the next clock-in already doesn't count, and the fixed break is then taken off too. On a 9:00 AM to 6:00 PM schedule with a 1h break, an employee who clocks out from 12:00 PM to 1:00 PM gets 7h hours worked instead of 8h, and Insufficient hours 1h.
With automatic break hour deduction, the fixed break comes off only on a full working day. A half-work day or a day with half-day leave has no break.
No worked time, no break. A day with no clock records, or only a clock-in, has 0 break hours.
On a flexible schedule, the expected end moves with the clock-in. With a Start time window of 8:00 AM to 10:00 AM, 8h work and a 1h break, an employee who clocks in at 8:00 AM is expected to leave at 5:00 PM, and one who clocks in at 10:00 AM at 7:00 PM.
Half-day leave moves the day's boundaries. On a 9:00 AM to 6:00 PM schedule with 8h work:
- Morning leave: the start becomes the end time minus half the work hours, so 2:00 PM. Late and counted time both start from there.
- Afternoon leave: the expected end becomes the start plus half the work hours, so 1:00 PM.

Pending records count before they're approved. Timesheets includes a clock record while it waits for approval. If it's later declined, cancelled or deleted, it's taken out.