Creation of a time recording for the employees of the Leica company in Zurich. The time recording is implemented using Microsoft Excel and VBA. Different working time models are taken into account, such as flexitime, shift work, overtime, weekend working hours and management contracts. The times can be entered manually in Excel and the balances are calculated per month and per year. Of course, public holidays and vacation days as well as special absences such as military, illness and accident are also taken into account in the calculation. The application was implemented using Microsoft Excel and Microsoft VBA.

• Developing dynamic time recording using Excel.
• Inregration overtime calculation.
• Integration of overtime calculation.
• Compliance with all internal guidelines.
• Compliance with all legal requirements.
• Calculation of the annual total.
• Calculation of monthly carry-overs.
• Sending PDF by email.