{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":76,"n_cols":11,"rows_kept":76,"cut":false,"hidden":false,"merged":[[13,1,13,12],[14,1,14,12]]}
["Je désire retrouver l'heure local (pour la France) à partir d'une date et heure UTC."]
[]
["Données exemple",null,"Date et Heure UTC",null,"Heure locale",null,"dernier samedi du mois ",null,{"$f":"7*INT(EOMONTH(DATE(YEAR($C$4),10,1),0)/7)","v":"2016-10-29"},null,"octobre"]
[1469527752000,null,{"$f":"IF(A4<>\"\", (A4+(\"1/1/1970\"-\"1/1/1900\"+1)*86400000)/86400000,\"\")","v":"2016-07-26T10:09:12"},null,{"$f":"IF(AND($C$4>$I$4,$C4<$I$3),$C$4+(2/24),$C$4+(1/24))","v":42577.506388888891},null,null,null,{"$f":"7*INT(EOMONTH(DATE(YEAR($C$4),3,1),0)/7)","v":"2016-03-26"},null,"mars"]
[1480000209000,null,{"$f":"IF(A5<>\"\", (A5+(\"1/1/1970\"-\"1/1/1900\"+1)*86400000)/86400000,\"\")","v":"2016-11-24T15:10:09"},null,{"$f":"IF(AND($C$5>$I$6,$C$5<$I$5),$C$5+(2/24),$C$5+(1/24))","v":42698.673715277779},null,"dernier samedi du mois ",null,{"$f":"7*INT(EOMONTH(DATE(YEAR($C$5),10,1),0)/7)","v":"2016-10-29"},null,"octobre"]
[null,"Date de départ",null,null,"Heure locale",null,null,null,{"$f":"7*INT(EOMONTH(DATE(YEAR($C$5),3,1),0)/7)","v":"2016-03-26"},null,"mars"]
["ou bien d'une date mini ou maxi",{"$f":"MIN(C4:C5)","v":"2016-07-26T10:09:12"},null,null,"="]
[null,{"$f":"MAX(C4:C5)","v":"2016-11-24T15:10:09"},null,null,"="]
["en résumé = si à la date on est dans les horaires d'été  >>>>>   l'heure UTC + 2 si non =UTC + 1"]
[]
["pour infos le changement heures d'été s'effectue le dernier samedi de mars (on passe en heure d'été)"]
["et  le changement heures d'hiver s'effectue le dernier samedi d'octobre"]
[]
[{"$f":"IF(AND(C4>DATE(YEAR(C4),3,32-WEEKDAY(DATE(YEAR(C4),3,31),1))+TIME(1,0,0),C4<=DATE(YEAR(C4),10,32-WEEKDAY(DATE(YEAR(C4),10,31),1))+TIME(1,0,0)),TIME(HOUR(C4)+2,MINUTE(C4),SECOND(C4)),TIME(HOUR(C4)+1,MINUTE(C4),SECOND(C4)))","v":"12:09:12"},"=SI(ET(C4>DATE(ANNEE(C4);3;32-JOURSEM(DATE(ANNEE(C4);3;31);1))+TEMPS(1;0;0);C4<=DATE(ANNEE(C4);10;32-JOURSEM(DATE(ANNEE(C4);10;31);1))+TEMPS(1;0;0));TEMPS(HEURE(C4)+2;MINUTE(C4);SECONDE(C4));TEMPS(HEURE(C4)+1;MINUTE(C4);SECONDE(C4)))"]
[{"$f":"IF(AND(C5>DATE(YEAR(C5),3,32-WEEKDAY(DATE(YEAR(C5),3,31),1))+TIME(1,0,0),C5<=DATE(YEAR(C5),10,32-WEEKDAY(DATE(YEAR(C5),10,31),1))+TIME(1,0,0)),TIME(HOUR(C5)+2,MINUTE(C5),SECOND(C5)),TIME(HOUR(C5)+1,MINUTE(C5),SECOND(C5)))","v":"16:10:09"},"=SI(ET(C5>DATE(ANNEE(C5);3;32-JOURSEM(DATE(ANNEE(C5);3;31);1))+TEMPS(1;0;0);C5<=DATE(ANNEE(C5);10;32-JOURSEM(DATE(ANNEE(C5);10;31);1))+TEMPS(1;0;0));TEMPS(HEURE(C5)+2;MINUTE(C5);SECONDE(C5));TEMPS(HEURE(C5)+1;MINUTE(C5);SECONDE(C5)))"]
[]
[]
["2013-03-25T12:30:01",{"$f":"IF(AND(A18>DATE(YEAR(A18),3,32-WEEKDAY(DATE(YEAR(A18),3,31),1))+TIME(1,0,0),A18<=DATE(YEAR(A18),10,32-WEEKDAY(DATE(YEAR(A18),10,31),1))+TIME(1,0,0)),TIME(HOUR(A18)+2,MINUTE(A18),SECOND(A18)),TIME(HOUR(A18)+1,MINUTE(A18),SECOND(A18)))","v":"13:30:01"},{"$f":"IF(AND(A18>DATE(YEAR(A18),3,32-WEEKDAY(DATE(YEAR(A18),3,31),1))+TIME(1,0,0),A18<=DATE(YEAR(A18),10,32-WEEKDAY(DATE(YEAR(A18),10,31),1))+TIME(1,0,0)),TIME(HOUR(A18)+2,MINUTE(A18),SECOND(A18)),TIME(HOUR(A18)+1,MINUTE(A18),SECOND(A18)))","v":"13:30:01"},"=SI(ET(A18>DATE(ANNEE(A18);3;32-JOURSEM(DATE(ANNEE(A18);3;31);1))+TEMPS(1;0;0);A18<=DATE(ANNEE(A18);10;32-JOURSEM(DATE(ANNEE(A18);10;31);1))+TEMPS(1;0;0));TEMPS(HEURE(A18)+2;MINUTE(A18);SECONDE(A18));TEMPS(HEURE(A18)+1;MINUTE(A18);SECONDE(A18)))"]
["2013-03-26T12:30:00.995",{"$f":"IF(AND(A19>DATE(YEAR(A19),3,32-WEEKDAY(DATE(YEAR(A19),3,31),1))+TIME(1,0,0),A19<=DATE(YEAR(A19),10,32-WEEKDAY(DATE(YEAR(A19),10,31),1))+TIME(1,0,0)),TIME(HOUR(A19)+2,MINUTE(A19),SECOND(A19)),TIME(HOUR(A19)+1,MINUTE(A19),SECOND(A19)))","v":"13:30:01"},{"$f":"IF(AND(A19>DATE(YEAR(A19),3,32-WEEKDAY(DATE(YEAR(A19),3,31),1))+TIME(1,0,0),A19<=DATE(YEAR(A19),10,32-WEEKDAY(DATE(YEAR(A19),10,31),1))+TIME(1,0,0)),TIME(HOUR(A19)+2,MINUTE(A19),SECOND(A19)),TIME(HOUR(A19)+1,MINUTE(A19),SECOND(A19)))","v":"13:30:01"}]
["2013-03-27T12:30:00.995","13:30:01","13:30:01"]
["2013-03-28T12:30:00.995","13:30:01","13:30:01"]
["2013-03-29T12:30:00.995","13:30:01","13:30:01"]
["2013-03-30T12:30:00.995","13:30:01","13:30:01"]
["2013-03-31T12:30:00.995","14:30:01","14:30:01"]
[]
["2017-10-22T12:30:01","14:30:01","14:30:01"]
["2017-10-23T12:30:00.995","14:30:01","14:30:01"]
["2017-10-24T12:30:00.995","14:30:01","14:30:01"]
["2017-10-25T12:30:00.995","14:30:01","14:30:01"]
["2017-10-26T12:30:00.995","14:30:01","14:30:01"]
["2017-10-27T12:30:00.995","14:30:01","14:30:01"]
["2017-10-28T12:30:00.995","14:30:01","14:30:01"]
["2017-10-29T12:30:00.995","13:30:01","13:30:01"]
["2017-10-30T12:30:00.995","13:30:01","13:30:01"]
["2017-10-31T12:30:00.995","13:30:01","13:30:01"]
["2017-11-01T12:30:00.995","13:30:01","13:30:01"]
["2017-11-02T12:30:00.995","13:30:01","13:30:01"]
["2017-11-03T12:30:00.995","13:30:01","13:30:01"]
["2017-11-04T12:30:00.995","13:30:01","13:30:01"]
["2017-11-05T12:30:00.995","13:30:01","13:30:01"]
["2018-03-18T12:30:00.995",{"$f":"IF(AND(A41>DATE(YEAR(A41),3,32-WEEKDAY(DATE(YEAR(A41),3,31),1))+TIME(1,0,0),A41<=DATE(YEAR(A41),10,32-WEEKDAY(DATE(YEAR(A41),10,31),1))+TIME(1,0,0)),TIME(HOUR(A41)+2,MINUTE(A41),SECOND(A41)),TIME(HOUR(A41)+1,MINUTE(A41),SECOND(A41)))","v":"13:30:01"},"13:30:01"]
["2018-03-19T12:30:00.995","13:30:01","13:30:01"]
["2018-03-20T12:30:00.995","13:30:01","13:30:01"]
["2018-03-21T12:30:00.995","13:30:01","13:30:01"]
["2018-03-22T12:30:00.995","13:30:01","13:30:01"]
["2018-03-23T12:30:00.995","13:30:01","13:30:01"]
["2018-03-24T12:30:00.995","13:30:01","13:30:01"]
["2018-03-25T12:30:00.995","14:30:01","14:30:01"]
["2018-03-26T12:30:00.995","14:30:01","14:30:01"]
["2018-03-27T12:30:00.995","14:30:01","14:30:01"]
["2018-03-28T12:30:00.995","14:30:01","14:30:01"]
["2018-10-25T12:30:00.995",{"$f":"IF(AND(A52>DATE(YEAR(A52),3,32-WEEKDAY(DATE(YEAR(A52),3,31),1))+TIME(1,0,0),A52<=DATE(YEAR(A52),10,32-WEEKDAY(DATE(YEAR(A52),10,31),1))+TIME(1,0,0)),TIME(HOUR(A52)+2,MINUTE(A52),SECOND(A52)),TIME(HOUR(A52)+1,MINUTE(A52),SECOND(A52)))","v":"14:30:01"},"14:30:01"]
["2018-10-26T12:30:00.995","14:30:01","14:30:01"]
["2018-10-27T12:30:00.995","14:30:01","14:30:01"]
["2018-10-28T12:30:00.995","13:30:01","13:30:01"]
["2018-10-29T12:30:00.995","13:30:01","13:30:01"]
["2018-10-30T12:30:00.995","13:30:01","13:30:01"]
["2018-10-31T12:30:00.995","13:30:01","13:30:01"]
["2018-11-01T12:30:00.995","13:30:01","13:30:01"]
["2018-11-02T12:30:00.995","13:30:01","13:30:01"]
["2019-03-24T12:30:00.995",{"$f":"IF(AND(A61>DATE(YEAR(A61),3,32-WEEKDAY(DATE(YEAR(A61),3,31),1))+TIME(1,0,0),A61<=DATE(YEAR(A61),10,32-WEEKDAY(DATE(YEAR(A61),10,31),1))+TIME(1,0,0)),TIME(HOUR(A61)+2,MINUTE(A61),SECOND(A61)),TIME(HOUR(A61)+1,MINUTE(A61),SECOND(A61)))","v":"13:30:01"},"13:30:01"]
["2019-03-25T12:30:00.995","13:30:01","13:30:01"]
["2019-03-26T12:30:00.995","13:30:01","13:30:01"]
["2019-03-27T12:30:00.995","13:30:01","13:30:01"]
["2019-03-28T12:30:00.995","13:30:01","13:30:01"]
["2019-03-29T12:30:00.995","13:30:01","13:30:01"]
["2019-03-30T12:30:00.995","13:30:01","13:30:01"]
["2019-03-31T12:30:00.995","14:30:01","14:30:01"]
["2019-04-01T12:30:00.995","14:30:01","14:30:01"]
["2019-04-02T12:30:00.995","14:30:01","14:30:01"]
["2019-04-03T12:30:00.995","14:30:01","14:30:01"]
["2019-04-04T12:30:00.995","14:30:01","14:30:01"]
["2019-04-05T12:30:00.995","14:30:01","14:30:01"]
["2019-04-06T12:30:00.995","14:30:01","14:30:01"]
["2019-04-07T12:30:00.995","14:30:01","14:30:01"]
["2019-04-08T12:30:00.995","14:30:01","14:30:01"]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}