中文版：请帮我制作一套员工考勤Excel管理表。

建立“员工信息”“每日考勤”“请假记录”“加班记录”“月度统计”和“考勤汇总”工作表。

每日考勤至少包含员工姓名、部门、日期、上班时间、下班时间、迟到分钟、早退分钟、工作时长和考勤状态。

根据设定的上下班时间自动判断正常、迟到、早退、缺勤等状态。

请自动汇总每位员工的出勤天数、迟到次数、早退次数、请假天数、加班小时数和实际工作时长。

使用条件格式突出异常考勤记录，并支持按照员工、部门和月份进行筛选。

英文版：Create an employee attendance management Excel workbook.

Create worksheets for employee information, daily attendance, leave records, overtime records, monthly statistics, and attendance summary.

Daily attendance should include employee name, department, date, clock-in time, clock-out time, late minutes, early-leave minutes, working hours, and attendance status.

Automatically determine whether each record is normal, late, early leave, or absent based on the defined work schedule.

Summarize attendance days, late arrivals, early departures, leave days, overtime hours, and actual working hours for each employee.

Use conditional formatting to highlight abnormal attendance records and allow filtering by employee, department, and month.

该提示词已在以下工具中验证有效：ChatGPT、Claude、Gemini、Copilot、WPS AI