{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"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":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["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"]
[1469527752000,null,{"$f":"IF(A4<>\"\", (A4+(\"1/1/1970\"-\"1/1/1900\"+1)*86400000)/86400000,\"\")","v":"2016-07-26T10:09:12"},null,"=",null,{"$f":"time_local()","v":"Local Date is:2017-1-24 Local Time is:21:59:13"}]
[1480000209000,null,{"$f":"IF(A5<>\"\", (A5+(\"1/1/1970\"-\"1/1/1900\"+1)*86400000)/86400000,\"\")","v":"2016-11-24T15:10:09"},null,"="]
[null,"Date de départ",null,null,"Heure locale",null,{"$f":"Time_UTC()","v":"UTC Date is:2017-1-24 UTC Time is:20:59:28"}]
["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"]

{"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":[]}