Export オーバータイムタイムインレコード (Excel)
ホーム > 管理モード > 打刻 Records > 輸出時計記録 > オーバータイムタイムインレコード (Excel)From the 管理モード home page, select 打刻 Records 及び Management, then choose 輸出時計記録 及び オーバータイムタイムインレコード. Select a month to export the overtime clock-in records. You can open 及び edit the exported file in Excel.
Data Format
| No. | Field | Description | Example |
|---|---|---|---|
| 1 | 日付 | Start date of the pai赤 clock-in record | 2026-04-03 (Fri) |
| 2 | Start Work | Time when the user (employee) clocked in to start work | 2026-04-03 02:59 |
| 3 | End Work | Time when the user (employee) clocked out after work | 2026-04-03 09:06 |
| 4 | 打刻 Duration | Total time from Start Work to End Work | 6h 7m |
| 5 | Work 時間 | 打刻 Duration truncated to a whole number of hours | 6 hrs |
打刻 Duration
Definition: 打刻 Duration is the total elapsed time from Start Work to End Work within the same pai赤 record.
計算: 打刻 Duration = End Work time − Start Work time
Example: If an employee clocks in for overtime at 6:00 p.m. 及び clocks out at 8:00 p.m., the 打刻 Duration is 2 hours.
記号:
- The system calculates the direct difference between Start Work 及び End Work. It does not currently subtract break time automatically.
Work 時間
Definition: Work 時間 is the 打刻 Duration truncated to a whole number of hours. This field does not mean that the system has identified or deducted break time.
計算: Work 時間 = 打刻 Duration with the minutes discarded
Example: If an employee clocks in for overtime at 5:57 p.m. 及び clocks out at 8:13 p.m., the 打刻 Duration is 2 hours 16 minutes, while Work 時間 displays 2 hours.
Additional information:
- 使用 the 打刻 Duration field when you need the minutes to be included.
Export オーバータイムタイムインレコード (CSV)
ホーム > 管理モード > 打刻 Records > 輸出時計記録 > オーバータイムタイムインレコード (CSV)From the 管理モード home page, select 打刻 Records 及び Management, then choose 輸出時計記録 及び オーバータイムタイムインレコード. The exported CSV uses 英語 column names. The table below explains each column.
| No. | CSV Column | Display Name | Description | Example |
|---|---|---|---|---|
| 1 | 使用r ID | 使用r ID | Unique identifier of the user (employee) | dReHKiseggH3kiOlhnj876fheKle |
| 2 | 従業員 ID | 従業員 ID | 従業員 number of the user (employee) | 1 |
| 3 | 従業員の名前 | 従業員の名前 | Name of the user (employee) | Lin Xiaoming |
| 4 | Time | 打刻 Time | 日付 及び time of the record in YYYY-MM-DD HH:MM format | 2025-11-20 09:00 |
| 5 | 状態 | 状態 | START means the start of work; END means the end of work |
START |
| 6 | Checkpoint | Checkpoint | Checkpoint used for the clock-in record | オフィス area |
| 7 | GPS | GPS Location (latitude, longitude) | GPS latitude 及び longitude of the clock-in record | 24.1731843,120.6611364 |
| 8 | WiFi | Wi-Fi | Wi-Fi name used when Wi-Fi clock-in restrictions apply | LOL520_2G |
| 9 | Bluetooth | Bluetooth | Bluetooth device name used when Bluetooth range restrictions apply | MSBeacon |
| 10 | NFC | NFC | NFC tag name 及び card serial number used for clock-in | NFC01 - D2:6B:94:00 |
| 11 | 承認 | Supplemental 打刻 | YES means this is a supplemental clock-in; blank means no |
YES |
| 12 | Created | Added by Manager | YES means the record was added by a manager; blank means no |
|
| 13 | 写真 | 写真 | YES means the employee uploaded a photo; blank means no |
YES |
| 14 | 記号s | 記号s | 記号 ente赤 by the employee when clocking in | Clocking in for work |
Export Data Availability
SwipePoint stores clock-in records permanently in the cloud. However, export permissions 及び the available date range depend on the organization's subscription status.
Export Options 及び Limits
The following limits apply based on whether the organization subscribes to the 組織 Ad-Free plan:
| Subscription 状態 | Records Available for Export | 日付 Range Limit |
|---|---|---|
| No 組織 Ad-Free subscription | Personal records only; Export All is unavailable. | Up to the most recent 2 months. |
| 組織 Ad-Free subscription active | Personal records or all records. | Up to 1 year of detailed records. |
Fix Garbled Text in 打刻 Record CSV Files
When you open a clock-in record CSV file in Excel for Windows, Chinese text may appear garbled if Excel does not detect the file's UTF-8 encoding correctly. 使用 either method below.
Method 1: Import the UTF-8 CSV in Excel
- Open Excel 及び create a blank workbook.
- Select
Data > Get Data > From File > From Text/CSV. Menu names may differ slightly by Excel version. - Select the CSV file you want to import.
- If File Origin or an encoding option is available, select
65001: Unicode (UTF-8)及び confirm that the delimiter is a comma. - Verify that the preview displays the text correctly, then select Load.
Method 2: Save the File as UTF-8 with BOM
- Open the CSV in a text editor that supports encoding selection, such as 記号pad++ or Visual Studio Code.
- Choose Save As.
- Select
UTF-8 with BOMas the encoding 及び save the file. - Reopen the saved file in Excel.
Do not convert the file to ANSI or Big5. Unsupported characters may be lost or become garbled.
よく聞かれる質問
Q1: How do I export overtime records?
A: From the 管理モード home page, select 打刻 Records 及び Management, then choose 輸出時計記録 及び オーバータイムタイムインレコード. You can then select the month to export.
Q2: Who can export overtime records?
A: Only users with 管理モード permission (managers) can export overtime records.
Q3: Which file formats are available?
A: You can export the records in Excel or CSV format 及び open them with Excel or other compatible software.
Q4: Which fields are included in the Excel export?
A: The export includes 日付, Start Work, End Work, 打刻 Duration, 及び Work 時間.
Q5: What is the difference between 打刻 Duration 及び Work 時間?
A: 打刻 Duration is the complete difference between the End Work 及び Start Work times. Work 時間 displays that duration as whole hours after discarding the minutes. Neither field currently subtracts break time automatically.
Q6: How do I choose the month to export?
A: On the 輸出時計記録 page, select オーバータイムタイムインレコード 及び specify the month to export.
Subscribers receive more immediate support. If you encounter an error or need help using SwipePoint, contact the SwipePoint team through the official ライン account. We will prioritize your request to help keep attendance management running smoothly. ライン ID: @nka7729y Contact the SwipePoint team
この手冊は正確性と完全性を確保するため、誤り、省略、更新については、責任を負いません. 内容は、事前に通知なしにいつでも変更することができる. 本手冊の使用やその内容のダウンロードによって発生する損害は、当社に責任はありません. システム故障、データ損失、または権利侵害に限定されない. ユーザは完全な責任とリスクを担う。