Excel Daily Task & Attendance Tracker

Hi,

I’m looking for a simple Excel attendance and daily task tracker that works completely offline using Excel VBA/macros.

This is meant to be a small and simple project, not a complicated HR system. You can use a premade Excel template and customize it if that’s easier.

I attached screenshots/mockups showing the idea and layout I’m looking for.

Budget:
Around $10–15 only, so please don’t bid high for this project.

Main Requirements:

1. Check In Button
When the user clicks “Check In”:

* Automatically record current date and current time from the computer system.
* Employee details should NOT come from the Windows/computer username.

Employee details should instead come automatically from a protected Admin sheet:

* Employee ID
* Employee Name
* Section / Branch Name

2. Check Out Button
When the user clicks “Check Out”:

* Automatically record checkout time
* Calculate total working hours
* Ask/check which tasks were completed
* Automatically calculate achievement %

Example:
3 tasks entered
2 completed
Achievement = 67%

3. Plan Tomorrow Button
Add a simple button called:
“Plan Tomorrow”

This should allow the user to prepare tomorrow’s plan or future entries without checking in/out.

The user should be able to:

* Select future date
* Select status/work type
* Add planned tasks manually

4. Tasks / Daily Plan
Tasks will be entered manually by the user.

Example:

* Review report
* Meeting
* Audit work

Then during checkout, the user can mark tasks as completed or not completed, and the percentage should calculate automatically.

I want this part to stay simple and lightweight, not a complicated task management system.

5. Dropdown Options
Simple dropdowns such as:

* Present
* Offsite Work
* Work From Home
* Sick Leave
* Annual Leave
* Official Mission
* Training
* Absent

Work location dropdown:

* Office / HQ
* Remote
* Site / Field
* Overseas

6. Monthly View
The file should be monthly based with a dropdown to switch/view months.
7. Admin Sheet
Add a hidden/password protected Admin sheet containing:

* Employee ID
* Employee Name
* Section / Branch Name

Only Admin should be able to edit these details.

8. Protection
The workbook should be protected so users cannot edit:

* Formulas
* Dates
* Time calculations
* Achievement %
* Employee details

Users should only be able to:

* Use buttons
* Enter tasks/plans
* Mark completed tasks
* Select dropdowns
* Write remarks

9. Design
Keep the design:

* Clean
* Simple
* Professional
* Easy to use

No heavy coding needed.

If you have a simpler or better way to achieve the same idea in Excel, that’s completely fine as long as it stays lightweight and offline.

Please check the attached screenshots carefully because they explain the workflow and idea in more detail.