View original (French)

Excel overtime management

scloer973 Posted messages 49 Registration date   Status Member Last intervention   -  
brucine Posted messages 25179 Registration date   Status Member Last intervention   -

Hello,

I would like to create a file for managing hours and automatically calculating overtime, and I would like to create an application on Excel if possible. Does anyone have these skills? We can discuss acquiring a file.

Best regards


3 answers

  1.
    georges97 Posted messages 14627 Registration date   Status Contributor Last intervention   2 944
     

    Hello,

    The question has been addressed several times, see whether the proposed solutions apply to your case and request adaptations if necessary:

    https://forums.commentcamarche.net/forum/affich-37883430-formule-condition-si

    https://forums.commentcamarche.net/forum/affich-37639571-excel-formule-plusieurs-conditions

    https://forums.commentcamarche.net/forum/affich-37639571-excel-formule-plusieurs-conditions

    https://forums.commentcamarche.net/forum/affich-37612211-formule-excel-pour-les-heures-supplementaires

    https://forums.commentcamarche.net/forum/affich-37597814-calcul-d-heures

    https://forums.commentcamarche.net/forum/affich-37514883-calculer-les-heures-supplementaires

    https://forums.commentcamarche.net/forum/affich-37381950-heures-supplementaires

    https://forums.commentcamarche.net/forum/affich-37381950-heures-supplementaires

    https://forums.commentcamarche.net/forum/affich-37337643-feuille-releve-heures

    https://forums.commentcamarche.net/forum/affich-37283114-totale-des-heures-supplementaire-echelle-entreprise

    https://forums.commentcamarche.net/forum/affich-37231959-calcul-des-heures-supplementaires-et-mise-en-formule-si


    https://forums.commentcamarche.net/forum/affich-38147587-calculer-le-nombre-d-heures-supplementaires-probleme

    Once the first draft is completed and any blocking issues brought to their attention, the specialists will be able to look into resolving them.

    1
  2. danielc0 Posted messages 2215 Registration date   Status Member Last intervention   294
     

    Hello,

    There are several templates built into Excel. Click on File, New. In the search box, enter "overtime" and confirm.

    Daniel

    0
  3. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     

    Hello

    Here is an old file that might help you with your problem

    the link

    https://www.swisstransfer.com/d/13e6afa4-ffd2-4aef-93bb-2416aea90356

    Check the parameters for overtime 25% 50% and ...

    0
    1. brucine Posted messages 25179 Registration date   Status Member Last intervention   4 166
       

      Hello,

      I have also done this kind of thing in the past.

      It seems difficult to propose a "universal" model because we need to know whether the table concerns a single employee or all employees of a company and we must take into account the specifics of the collective agreement (thresholds and rates for overtime, potential evening, night, public holiday work, absences...).

      In any case, the principle is always the same: establish a typical schedule for each employee, which can become more complex if everyone has different standard weeks due to shifts, enter the actual hours into another sheet and compare; there aren't any particular difficulties, just a bit of calculation to consider these various factors.

      In my opinion, we will only be able to do this optimally if we have a fictitious file showing this organization.

      0