Export Units for Work Hours and Absences

Different export units can be used for work hours and absences.
Depending on the selected unit, the same entry is converted differently.

This page documents the actual runtime behavior of each unit.

Units and behavior

Unit	Runtime behavior
HOURS	Sums seconds and divides the result by 3600.
HOURS_BY_INPUT	Absence-only: uses originalDuration / 3600. Not supported for work-hour and time-balance conversions.
DAYS	Work hours: divides by contract daily workload. Absences: divides by absence all-day duration. Also supported for time balances.
DAYS_BY_INPUT	Absence-only: if overrideAllDayDurationInSeconds > 0, uses originalDuration / overrideAllDayDurationInSeconds, otherwise originalDurationInPercent / 100. Not supported for work-hour and time-balance conversions.
AFFECTED_DAYS	Counts unique effectiveDate days touched by entries.
WORKING_DAYS	Per day: more than 5 hours counts as 1, otherwise 0.5. Then summed across days.
COUNT	For entry conversion: number of entries (entries.length). Not supported for time-balance conversion.

Important notes

• Not every unit is available for every export type.
• HOURS_BY_INPUT and DAYS_BY_INPUT are intended for absence logic only.
• For time-balance conversions, use only units that explicitly support time balances.

Where is this used?

• Work Export
• Absence Export
• Time Balance Excel Export