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] Download Sample Excel File 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. |
User Guide >