View original (French)

Excel spreadsheet for day quota calculation and time tracking

Laurence -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   -

Hello,

I am looking for a time tracking table for executives and employees with a count of days off/vacation...

Thank you in advance for your response


6 answers

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

    Hello

    An idea in the attached file available for 4 days

    Planning-work-218-days-2023-time-tracking-100-th-hour-month-start-January-Alsace-Moselle-regime-option-RTT-calculation.xlsm (cjoint.com)

    Enjoy using it

    0
    1. Laurence
       

      Hello,

      What a job. Thank you very much.

      Have a nice day

      0
    2. Sou
       

      Hello,

      I would like to ask if it is possible to make your work schedule file for 218 days available?

      Best regards

      0
    3. Mp
       

      Hello, Would it be possible to access the document, please? Thank you very much for your work.

      0
      1. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835 > Mp
         

        Hello Mp

        Here is the requested link

        https://www.cjoint.com/c/MKpoxxCOnw4

        Enjoy using it

        0
      2. Mp > PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention  
         

        Thank you very much!

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

    Hello Sou

    The requested link

    Planning-218-working-days-2023-time-tracking-100th-hour-month-start-january-Alsace-Moselle-regime-option-RTT-calculation.xlsm (cjoint.com)

    Enjoy using it

    0
    1. mrc
       

      Hello

      Is it possible to have your link for feedback, thank you

      0
    3. sandthev Posted messages 1 Registration date   Status Member Last intervention   > PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention  
       

      Hello PHILOU10120

      I would also like to receive this link (since the last link has already expired).

      Is it possible to adapt the day package of 218 days to a reduced time day package?

      Thank you in advance for your response.

      0
    4. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835 > sandthev Posted messages 1 Registration date   Status Member Last intervention  
       

      Hello Sandthev

      The requested link

      https://www.cjoint.com/c/NBtoVjwwUH4

      Available for 21 days

      Cell AT11 to adjust the number of days worked

      0
    5. alex13 > PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention  
       

      Hello,

      I would like to receive the link as well, it has expired.

      Best regards;

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

    Hello

    The new file is ready.

    Work schedule 218 days of work - 2026

    Here is the link to the file for 2026

    https://www.swisstransfer.com/d/c301acdd-f056-4d25-bc8e-2a5aee0ac6aa

    Enjoy using it

    If you have any comments, I’m open to them

    0
    1. UFAL75 Posted messages 9 Registration date   Status Member Last intervention  
       

      Good evening Philou10120,

      Would you have a work schedule for 2026 for 204 working days?

      Thank you in advance,

      0
      1. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835 > UFAL75 Posted messages 9 Registration date   Status Member Last intervention  
         

        Hello UFAL75

        The file from post 14 is still available for download. Accept the macros, then modify cell AU11 to 204 instead of 218, and insert RTT in the calendar to get 24, and it's ready.

        Save the file

        Enjoy using it

        0
    2. Finmag
       

      Hello,

      Is it still possible to have an active link for the 2026 file?

      Best regards

      0
  6. UFAL75 Posted messages 9 Registration date   Status Member Last intervention  
     

    Hello Philou10120,

    Thanks for the tip, it works perfectly!

    Have a great day,

    0