User Guide‎ > ‎

How to import Global Working Hours from Excel?

Create an Excel Spreadsheet with the following fields at the Row 1:

[WORK_HRS_TYPE]
[DESCRIPTION]
[IN_TIME]
[IN_TIME_BEFORE]
[OUT_TIME]
[SAT_OUT_TIME]
[OUT_TIME_AFTER]
[LATE_TOLERANCE]
[LT_ONLY_IF_OT_FOR_HRS]
[LATE_TOLERANCE2]
[LT2_ONLY_IF_OT_FOR_HRS]
[EARLY_OUT_TOLERANCE]
[INCLUDE_LUNCH_HOUR]
[PAY_LUNCH_BREAK]
[ENABLE_LUNCH_TIME]
[LUNCH_OUT_TIME]
[LUNCH_OUT_TOLERANCE]
[LUNCH_OUT_SCAN_FROM]
[LUNCH_OUT_SCAN_TO]
[LUNCH_IN_TIME]
[LUNCH_IN_TOLERANCE]
[LUNCH_IN_SCAN_FROM]
[LUNCH_IN_SCAN_TO]
[OT_MINIMUM_MINS]
[OT_MAXIMUM_HRS]
[OT_ALLOW_EARLYTIME]
[OT_TRUNCATETO_QUARTER]
[OT_PAY_INCLUDED_MINIMUM_MINS]
[WORK_HRS]
[LUNCH_HRS]
[SAT_HRS]
[SATURDAY_OFF]
[LATE_DEDUCTION]
[EARLYOUT_DEDUCTION]
[SATURDAY]
[EXCLUDE_EARLIER_THAN_IN_TIME]
[OT_HRS_BASE_ON_WORKED_HRS]
[LATE_IN_EXCLUDE_LATE_TOLERANCE]
[EARLY_OUT_EXCLUDE_EARLY_OUT_TOLERANCE]


To get the full list of fields of Global Working Hours of your version in Excel, press the Export button on Global Working Hours to export a full list of fields that match your version.