...
- Open the Import from Excel settings.
- Select the required date format from the available options. Open the list of available date formats in the Common formats folder. Select the date format that matches the format used for dates in your Excel file.
...
Important: The value entered for the Excel Time Type must exactly match the value used in the Excel file. The system considers letter case, spaces, and other characters when matching the value. If the value does not match exactly, the Time Type may not be recognized during import.
Example:
| Value in Excel | System Work Time Type |
|---|---|
| Working hours | WO |
| REGULAR OVERTIME | OT |
In this example, the values Working hours and REGULAR OVERTIME must be entered in the mapping exactly as they appear in the Excel file.
...