Business solutions for you portfolio


Company: Leica, Zurich

Technology: MS Excel, VBA.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Okt 2018 – Jan 2019

Cost: no details

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

  • Develop a dynamic time recording system using Excel.
  • Integration of overtime calculation.
  • Integration of overtime calculation.
  • Compliance with all internal guidelines.
  • Compliance with all legal requirements.
  • Calculation of annual totals.
  • Calculation of monthly carryovers.
  • Sending of PDF by e-mail.
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52

Order a project
Tell us what kind of project you want to do.
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.