View original (French)

Convert hours to days

Solved
Alan357 Posted messages 89 Status Member -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   -
Hello,
I created an overtime management tool, and in my summary table, I would like my total hours (which is in hour format 00:00:00) to be converted into days in another cell. Knowing that 1 day = 7 hours.
Thank you in advance

Best regards,

2 answers

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

    the total hours in A1

    =INT(A1/(1/24*7))

    --
    It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from one's mistakes.
    4
    1. Alan357 Posted messages 89 Status Member
       
      Thank you Philou, but it doesn't work!
      0
    2. Alan357 Posted messages 89 Status Member
       
      Yes, that's good, but I would like to have figures after the decimal point, for example 2.5 days. Or even better, 2 days and 3 hours 30 minutes.
      0
      1. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835 > Alan357 Posted messages 89 Status Member
         
        =INT(A1/(1/24*7))" Day(s) "&TEXT(A1-INT(A1/(1/24*7))*(1/24*7);"HH:MM")
        0
  2. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    try this

    =INT(A1/(1/24*7))" J "&TEXT(A1-INT(A1/(1/24*7))*(1/24*7);"HH:MM")

    --
    It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from their mistakes.
    0
    1. Alan357 Posted messages 89 Status Member
       
      Thank you very much.
      0