- First confirm which day the times come from, whether they cross midnight, and that rest is measured in hours; times are Excel day decimals, 21:30 is 21.5/24, and a rest of 0.5 is half an hour, so the two units must not be mixed.
- Build the worksheet with separate input and formula areas; MOD handles a single midnight crossing, and rest exceeding the interval, negative rest, non-numeric values, and equal times all prompt for verification.
- Distinguish unfilled times from midnight 0. Totals count only valid rows, but an incomplete prompt is also shown; 16 hours must not be treated as all shifts verified.
- Keep the inputs, modify the clock-in and clock-out times in a copy and read back the results; in XLSX, formulas and time display formats must both be preserved.
First read actual methods, parameters, and session and complete parameter template. Inputs and example values must be replaced per the task; for an existing workbook, first check the worksheets and occupied ranges, choose a unique new sheet name for this task, and do not overwrite the original sheet.
When an embedded view is needed, hand it to the gridcraft-editor skill. Standalone installation:npx skills add full-aigc-skills/gridcraft-skills --skill gridcraft-editor. This batch is a development candidate and has not yet entered a new market version.
The two valid examples are 8 hours each, totaling 16; rows with missing values and rest exceeding the interval are not counted and have prompts. Recalculate after modifying times, midnight 0, and missing/invalid values.
Contains only times, with a maximum of less than 24 hours; identical times cannot be inferred to be zero hours or a full day, so mark for verification. Multi-day crossings require full dates for separate calculation. The template does not calculate wages, overtime, or applicable labor rules.
Save as an editable XLSX and reopen it, modify inputs to verify recalculation. The existence of rules does not mean all API writes will enforce input interception; calculation results and abnormal prompts must be verified. External Excel formatting, real business content, and host synchronization are accepted separately.Fixed GitHub source and license。