iPad Time Tracking App

I have an excel spreadsheet which I use for production scheduling in my factory. I want people to be able to clock onto existing jobs in our factory using a communal iPad. I want an app that they can go to and log in using their unique 4 digit number. Once they log in, I want the jobs (from a column in my production schedule) to be visible. They should be then able to choose 1 and clock onto it. They should then hit a "log out" button. Once they go back to the iPad later and log back in using their pin, it will show that they are clocked onto the job from earlier. They can then click "done" and it will save the amount of time spent, to another sheet on my spreadsheet. It will show their name, job name, and time spent. They can then clock onto another job. I also want them all to be able to clock onto work in the morning and clock out in the afternoon. This info should be saved on a separate sheet of my production schedule which is just used for payrolls.


Core workflow
• A single shared login protects the app; once entered, it stays active unless logged out.
• The user chooses a job from a list (pulled from columns on the production schedule), taps Start, and the app writes the timestamp.
• It should also record overall daily hours for payroll. The app records the overall daily time, calculates regular hours, then splits anything beyond the daily limit into overtime.
• All writes happen through the OneDrive connection so the spreadsheet stays the single source of truth, even if several iPads are active simultaneously. Offline entries should queue and sync automatically when a connection returns.
Daily payroll clock times should round up to the nearest 15 mins on clock in. Round down to nearest 15 mins on clock off.
Job/task log ons should be rounded to nearest minute.

Key features (checkbox selections)
• Start/stop timer
• Job assignment
• Individual logins/pins
• Time keeping
• Overtime calculation
•Weekly time stored from Wednesday to Tuesday. New rows to be added at the top of the sheet every week, so old weekly times can be viewed by scrolling down.
•

Deliverables
1. Xcode project written in Swift or SwiftUI, ready for TestFlight distribution.
2. Simple configuration screen where I can update the OneDrive file path and overtime threshold etc.
3. Short setup document covering OneDrive app registration, permissions and how to redeploy.

Acceptance criteria
• A test run on my iPad shows data appearing instantly in the designated Excel columns.
• Overtime calculation is accurate against the threshold I set.
• No user can reach any data without the shared password.

If you are comfortable with Microsoft Graph, Excel APIs and clean native iPad interfaces, this should be a fast, rewarding build.