{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Présence","Paramêtre"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Présence","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,6,22,"R",1]
[]
[null,"Équipe","Entrée","Sortie","Durée Présence","Nuit","Panier","Panier","Heure 25%","Heure 50%"]
["Dimanche",null,{"$f":"IFERROR(INDEX(entrée,MATCH($B4,équipe,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(sortie,MATCH($B4,équipe,0),1),\"\")","v":""},{"$f":"IF(COUNT(C4:D4)=0,\"\",MOD(D4-C4,24))","v":""},{"$f":"IF(COUNT(C4:D4)=0,\"\",MOD($D4-$C4,24)-($D4<$C4)*($D$1-$C$1)-MEDIAN($D4,$D$1,$C$1)+MEDIAN($C4,$D$1,$C$1))","v":""},{"$f":"IF(F4=7,E1,\"\")","v":""},{"$f":"IF(COUNT(C4:D4)=0,\"\",IF(F4=7,F1,\"\"))","v":""}]
["Lundi","5h",5,13,{"$f":"IF(COUNT(C5:D5)=0,\"\",MOD(D5-C5,24))","v":8},{"$f":"IF(COUNT(C5:D5)=0,\"\",MOD($D5-$C5,24)-($D5<$C5)*($D$1-$C$1)-MEDIAN($D5,$D$1,$C$1)+MEDIAN($C5,$D$1,$C$1))","v":1},{"$f":"IF(F5=7,E1,\"\")","v":""},{"$f":"IF(COUNT(C5:D5)=0,\"\",IF(F5=7,F1,\"\"))","v":""}]
["Mardi","21h",21,5,{"$f":"IF(COUNT(C6:D6)=0,\"\",MOD(D6-C6,24))","v":8},{"$f":"IF(COUNT(C6:D6)=0,\"\",MOD($D6-$C6,24)-($D6<$C6)*($D$1-$C$1)-MEDIAN($D6,$D$1,$C$1)+MEDIAN($C6,$D$1,$C$1))","v":7},{"$f":"IF(F6=7,E1,\"\")","v":"R"},{"$f":"IF(COUNT(C6:D6)=0,\"\",IF(F6=7,F1,\"\"))","v":1}]
["Mercredi","Vacance","CP","CP",{"$f":"IF(COUNT(C7:D7)=0,\"\",MOD(D7-C7,24))","v":""},"",{"$f":"IF(F7=7,E1,\"\")","v":""},{"$f":"IF(COUNT(C7:D7)=0,\"\",IF(F7=7,F1,\"\"))","v":""}]
["Jeudi","19h",19,5,10,7,{"$f":"IF(F8=7,E1,\"\")","v":"R"},{"$f":"IF(COUNT(C8:D8)=0,\"\",IF(F8=7,F1,\"\"))","v":1}]
["Vendredi","A/Midi",13,21,8,0,{"$f":"IF(F9=7,E1,\"\")","v":""},{"$f":"IF(COUNT(C9:D9)=0,\"\",IF(F9=7,F1,\"\"))","v":""}]
["Samedi",null,"","",{"$f":"IF(COUNT(C10:D10)=0,\"\",MOD(D10-C10,24))","v":""},{"$f":"IF(COUNT(C10:D10)=0,\"\",MOD($D10-$C10,24)-($D10<$C10)*($D$1-$C$1)-MEDIAN($D10,$D$1,$C$1)+MEDIAN($C10,$D$1,$C$1))","v":""},{"$f":"IF(F10=7,E1,\"\")","v":""},{"$f":"IF(COUNT(C10:D10)=0,\"\",IF(F10=7,F1,\"\"))","v":""}]
[null,null,{"$f":"IF(COUNT(E4:E10)=0,\"\",SUM(E4:E10))","v":34},"Total:",{"$f":"IF(COUNT(E4:E10)=0,\"\",MIN(35/24*24,SUM(E4:E10)))","v":34},{"$f":"IF(COUNT(F4:F10)=0,\"\",SUM(F4:F10))","v":15},{"$f":"H11","v":2},{"$f":"IF(COUNT(H4:H10)=0,\"\",SUM(H4:H10))","v":2},{"$f":"IF(COUNT(C11-E11)=0,\"\",MIN(8/24*24,SUM(C11-E11)))","v":0},{"$f":"IF(COUNT(C11-E11-I11)=0,\"\",SUM(C11-E11-I11))","v":0}]
[]
[]
[]
[null,null,"Bonjour,"]
[null,null,"Comment faire pour que ma formule perne en compte"]
[null,null,"Ex : C7 : D7    CP,CP  (E7=7,00)"]
[null,null,"Tout en gardant ma formule en (E7)"]
[null,null,"=SI(NB(C7:D7)=0;\"\";MOD(D7-C7;24))"]

{"sheet":"Paramêtre","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["5h",5,13]
["19h",19,5]
["21h",21,5]
["A/Midi",13,21]
["Vacance","CP","CP"]