View original (French)

Convert hours to days

Solved
Alan357 Posted messages 89 Status Membre -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur 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 réponses

Réponse 1 / 2
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
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
Alan357 Posted messages 89 Status Membre
 
Thank you Philou, but it doesn't work!
0
Alan357 Posted messages 89 Status Membre
 
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
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833 > Alan357 Posted messages 89 Status Membre
 
=INT(A1/(1/24*7))" Day(s) "&TEXT(A1-INT(A1/(1/24*7))*(1/24*7);"HH:MM")
0
Réponse 2 / 2
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
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
Alan357 Posted messages 89 Status Membre
 
Thank you very much.
0