View original (French)

Calculate two-thirds of a period

EricLeD Posted messages 11 Status Member -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello everyone,

I am facing a difficulty, and I thank you in advance for your help:
I have a seniority calculation table for employees that allows for entering the names of different companies, the contract dates (start and end), and the formulas calculate the duration of the contract as well as the cumulative duration of all contracts. So far...
I need to calculate, for contracts that are not directly related to the activity, 2/3 of the duration of those contracts and integrate this result in years, months, and days. The field "establishments of the same nature" allows for entering "yes/no"

for example:



I need to find the formula that allows dividing time by 2/3 based on the data present in my table.

Does anyone have an idea?

4 answers

  1.
    via55 Posted messages 14392 Registration date   Status Member Last intervention   2 759
     
    Hello

    I don’t understand your concern; apparently, you have the calculation formulas to convert into months and years in your table; all you have to do is apply them to the result of the 2/3 calculation
    unless there’s something I didn’t understand!

    --
    "Imagination is more important than knowledge." A. Einstein
    1
    1. EricLeD Posted messages 11 Status Member
       
      Damn... you're right, I'm stressing myself trying to apply it to the result when I just need to do it based on the number of days... I'll check it out right away. Thanks for your reply.
      0
  2. via55 Posted messages 14392 Registration date   Status Member Last intervention   2 759
     
    Hello

    If you want to take 2/3, you need to multiply by 2/3, that is, for a number of hours in C2:
    =C2*2/3

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    0
  4. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     

    Hello to both of you.

    A suggestion, to be adjusted as you see fit:
    In C11 enter =C6
    In D11 =C6+(D6-C6)*2/3
    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0