Find attendance exceptions in your punch report
'Sir, punch nahi hua' – every single morning
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Export the punch report
Export employee-code punch records and approved leaves. Include a roster or schedule of every employee's expected working dates for the review period, including employees with no punches at all.
Delete names
Keep only employee codes. Names, phone numbers, anything else personal: delete.
Privacy Use employee codes and approved schedules only. Remove names, phone numbers and biometric identifiers; keep actual payroll and identifiable records local.
I'm attaching three Excel files for [Review dates]: punch report (employee code, date, in/out), approved leaves (employee code, date, approved status), and expected roster (employee code, scheduled working dates or approved workday pattern). Only the roster defines expected employee-days; do not infer absence from a missing row or assume every calendar day is working. Approved rules: shift starts [Shift starts], grace [Grace] minutes. Elapsed in-to-out time at least [Full day] hours is full day, under [Half day under] hours is half day. If thresholds overlap or leave a gap, flag rule conflict or intermediate day for HR; do not invent break deductions. Same-day shifts unless the roster explicitly identifies a night shift. A. For every scheduled employee-day, validate roster, dates, unique punch rows and in/out times. Late only if in time is later than start plus grace. Missing in/out, duplicate/conflicting punches, invalid/reversed times without approved night shift, and partial/missing records go to review. No punch on a scheduled working day is absent only if there is no approved leave for that day; list approved leaves separately. A missing employee-day roster is unknown, not absence. B. Exception table: code, date, scheduled status, times, exact rule and reason. Count approved leave, late, half day, missing punch and absent without leave separately; overlapping flags may apply to one employee-day. C. Per employee summary and total scheduled days reconciled to present/half day, approved leave, absence and unresolved records. Show elapsed time, not actual payable hours. Ask HR to confirm exceptions and corrections; no salary deduction or pay decision. Use only the supplied roster, times and approved rules. Remove personal details and keep actual biometric records local if company policy requires. Do not repeat personal identifiers from the data (personal names, phone numbers, email or postal addresses, bank account numbers, UPI IDs, PAN, Aadhaar, GSTIN or other registration numbers) unless the output genuinely needs one; use the code, ref or row instead, and copy any needed identifier exactly. Keep masked values masked; never guess, complete or unmask them.
Which model? This task is about times and counts, so use your tool's strongest model with thinking (or extended reasoning) turned on.
In your AI tool: attach the files with the + button, paste, send.
Office doesn't allow uploading files? Ask AI for a formula instead. It never sees your data.
Excel Roster A:B = employee code and scheduled date (one row per scheduled working day); Punch A:D = employee code, date, in, out; Leave A:C = employee code, date, approved status. Shift [Shift starts], grace [Grace] minutes; full day [Full day] hours, half day under [Half day under]; period [Review dates]. Give COUNTIFS/XLOOKUP formulas for matching scheduled employee-days to punch and approved leave, duplicate/missing punch flags, late and elapsed hours, absence only if scheduled with no punch and no approved leave, and per-employee totals. Hold conflicting or reversed times unless approved night shift; no pay deductions.
Fill down for all roster employee-days, including those with no punch rows. Verify leave and exceptions with HR before any attendance correction or payroll action.
- E10312 Nov, no out-punch. Missing punch, not a half day yet. Ask the employee and their manager first.
- E10412 Nov, absent. No leave applied. 11 Nov is their approved CL, so that day is fine.
- E10513 Nov, 4 hrs 35 min. Under 8 hours, so half day as per your rule, unless leave is applied.
Then send this: Reconcile every scheduled employee-day to the roster, including employees with no punches. Recheck approved leave, late boundary, elapsed time, duplicate/missing punches and overlapping flags; no pay decision.
Times are read wrongly
Your export may have times as text or in 12-hour format. Add: "Times are in 24-hour HH:MM format."
Night shifts break it
Supply approved night-shift roster and dates. Hold reversed times without a confirmed night shift.
The answer stops halfway
Type "continue". For a big team, send one department at a time.
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.