How to import Global Working Hours from Excel?

Create an Excel Spreadsheet with the following fields at 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.

Sample Import File: 3.GlobalWorkingHours.xlsx⇩