Employee Attendance Data Entry
Budget: ₹100 – ₹400 INR
I need our employee attendance records typed and organised in Microsoft Excel so they slot straight into the business-report templates we use each month. All source material—daily time-sheet scans and a small CSV export from the biometric system—will be in English and will be shared through Google Drive.
The worksheet must:
• list every employee once, with dates running across the columns;
• flag absences and late check-ins exactly as marked on the raw sheets;
• total working days, presents, absents and late arrivals with simple SUM/COUNT formulas that I can audit quickly.
Accuracy is critical; even a single missed day skews payroll. A quick turn-around is appreciated, but not at the expense of double-checking each entry before you hand the file back.
Please keep the file in .xlsx format only, no macros or VBA required.
The worksheet must:
• list every employee once, with dates running across the columns;
• flag absences and late check-ins exactly as marked on the raw sheets;
• total working days, presents, absents and late arrivals with simple SUM/COUNT formulas that I can audit quickly.
Accuracy is critical; even a single missed day skews payroll. A quick turn-around is appreciated, but not at the expense of double-checking each entry before you hand the file back.
Please keep the file in .xlsx format only, no macros or VBA required.