{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Feuil1","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["début au format décimale","fin au format décimale","Résultat en décimale","Résultat au format heures:minutes"]
[22.5,7.1,{"$f":"IF(A2=\"\",\"\",IF(A2>B2,MOD(24,A2-B2),B2-A2))","v":8.6},{"$f":"IF(A2=\"\",\"\",IF(A2>B2,MOD(24,A2-B2)/24,(B2-A2)/24))","v":"08:36:00"}]
[20.149999999999999,5,8.8500000000000014,{"$f":"IF(A3=\"\",\"\",IF(A3>B3,MOD(24,A3-B3)/24,(B3-A3)/24))","v":"08:51:00"}]
[13,17.3,4.3000000000000007,{"$f":"IF(A4=\"\",\"\",IF(A4>B4,MOD(24,A4-B4)/24,(B4-A4)/24))","v":"04:18:00"}]
[]
[]
["Si tout le tableau est au format H:MM"]
["début","fin","Résultat H:MM","Résultat en décimal "]
["12:10:00",7.1,{"$f":"SUM(\"24\"-A9,B9)","v":30.593055555555559},{"$f":"(SUM(\"24\"-A9,B9)-INT(SUM(\"24\"-A9,B9)))*24","v":14.233333333333405}]
[20.149999999999999,5.0069444444444446,{"$f":"SUM(\"24\"-A10,B10)","v":8.8569444444444461},{"$f":"(SUM(\"24\"-A10,B10)-INT(SUM(\"24\"-A10,B10)))*24","v":20.566666666666706}]
[13.145833333333334,17.3,{"$f":"SUM(\"24\"-A11,B11)","v":28.154166666666669},3.7000000000000455]
[]
[null,null,null,{"$f":"IF(AND(ISNUMBER(A9),ISNUMBER(B9)),(SUM(\"24\"-A9,B9)-INT(SUM(\"24\"-A9,B9)))*24,\"\")","v":14.233333333333405}]
[null,null,null,{"$f":"IF(AND(ISNUMBER(A10),ISNUMBER(B10)),(SUM(\"24\"-A10,B10)-INT(SUM(\"24\"-A10,B10)))*24,\"\")","v":20.566666666666706}]
[null,null,null,3.7000000000000455]