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

HOURS

Seconds are added together and divided by 3600.

Example: 7200 seconds become 2 hours.

HOURS_BY_INPUT

Only for absences. The originally entered duration is used:

originalDuration / 3600

This is relevant when the input itself was entered as an hour value. It is not supported for work hours or time balances.

DAYS

Converts hours or seconds into days.

For work hours, the value is divided by the daily target working time from the contract.

Example: the contract says 8h per day, the exported value is 4h -> 0.5 days.

For absences, the value is divided by the all-day duration of the absence.

Example: all day = 8h, absence = 8h -> 1 day.

This unit is also supported for time balances.

DAYS_BY_INPUT

Only for absences. This tries to use the originally entered day logic as much as possible.

If overrideAllDayDurationInSeconds > 0, then:

originalDuration / overrideAllDayDurationInSeconds

Otherwise:

originalDurationInPercent / 100

Examples:

• originalDurationInPercent = 50 -> 0.5 days
• originalDurationInPercent = 100 -> 1 day

This is not supported for work hours or time balances.

AFFECTED_DAYS

Counts the number of unique affected days based on effectiveDate.

Example: entries on Monday, Tuesday, and Tuesday -> the exported value is 2, because two different days are affected.

WORKING_DAYS

Evaluates each day based on how much working time falls on that day:

• More than 5 hours = 1 working day
• Otherwise = 0.5 working day

All days are then summed.

Example:

• Monday 6h -> 1
• Tuesday 4h -> 0.5
• Export value -> 1.5

COUNT

Counts the number of entries:

entries.length

Example: three absence entries -> 3.

COUNT is 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.
• COUNT is used only for entries and not for time-balance conversions.
• For time-balance conversions, use only units that explicitly support time balances.

Where is this used?

• Work Export
• Absence Export
• Time Balance Excel Export