Upload Attendance File

Select your Excel file containing the Attendance-Master sheet

📁

or click to browse · .xlsx / .xls

Expected columns → B: Name C: Department G: Punch-In Time

Configure Rounds

Har round mein ek se zyada time slots — har slot ka apna range, late-day filter aur penalty

Paste into Excel — works with the Attendance-Master sheet

1

Open VBA Editor

Press Alt + F11 in Excel — the VBA editor will open

2

Insert Module

Click Insert → Module — a new module window will appear

3

Paste Code

Click "Copy Code" above, then press Ctrl + V in the module window

4

Run Macro

Alt + F8 → select RunFullAttendanceReport → Run

View date-wise attendance details for any employee

🏢 Departments

0 selected All None

🔍 Select Employees

0 selected All None

⏰ Penalty Time Slots

Define time ranges with different penalties. Each slot calculates penalty separately.

No data picked yet.

📥 Paste Bilty Data

Excel/Sheet se rows copy karke niche paste karein. Tab-separated ya comma-separated dono chalenge.

📋 Picked Rows Preview

Paste data and click "Pick Data" to preview rows.