I will build a custom excel employee schedule tracker
Excel and CSV Automation
About this Gig
If you're tracking employee shifts on paper or in a spreadsheet that doesn't calculate anything, I'll build a custom Excel schedule tracker around your team.
Log start and end times for each shift, and the workbook automatically calculates hours worked and weekly totals per employee - including overnight shifts that cross midnight. No macros, no VBA, no add-ins.
WHAT YOU GET
A schedule tracker built around YOUR team and shift patterns, not a generic template
Formula-only design - works the same on Windows and Mac, no "enable macros" prompt
A short plain-language guide for day-to-day use
HOW I WORK
Built with AI-assisted development (Claude Code) for speed, but I confirm requirements first, design test cases (overnight shifts, missing entries, unlisted employees), and check the file before delivery. Built on your data, not copy-pasted.
GOOD TO KNOW
I can work directly from Japanese-language staff lists if relevant. Send your team size and shift pattern first.
NOT COVERED: payroll/wage calculations, POS or time-clock integration, multi-location scheduling.
Message me your team size and shift pattern, and I'll confirm the right package.
Technology:
Excel
Expertise:
Data manipulation
My Portfolio
FAQ
Do I need to enable macros?
No - this is built entirely with formulas, no VBA/macros required.
Does it handle overnight shifts?
Yes - shifts that cross midnight (e.g. 10pm to 6am) are calculated correctly.
How many employees can it support?
It depends on the package - message me your team size first for a custom quote.
Will it calculate wages or pay?
Not in this gig - payroll and wage calculations are outside the scope.
What do you need from me to get started?
Just a rough list of your employees and typical shift pattern - a screenshot or note is fine.

