{"id":338,"date":"2014-04-25T19:54:51","date_gmt":"2014-04-25T17:54:51","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=338"},"modified":"2022-11-03T16:30:01","modified_gmt":"2022-11-03T15:30:01","slug":"excel-additionner-des-heures-et-des-minutes-2","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/04\/excel-additionner-des-heures-et-des-minutes-2\/","title":{"rendered":"Excel &#8211; Additionner des heures et des minutes"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous avez cr\u00e9\u00e9 un tableau comportant une colonne dans laquelle vous avez saisi des heures et des minutes (8:30, 7:20, 9:15&#8230; pour inscrire par ex. vos horaires de la semaine). Vous pr\u00e9voyez de faire une addition des heures au bas du tableau. Probl\u00e8me : l&rsquo;addition (=Somme&#8230;) renvoie un r\u00e9sultat erron\u00e9.<\/p>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li>Cliquez sur la cellule dans laquelle vous avez ins\u00e9r\u00e9 la fonction Somme<\/li>\n<li>Faites un clic droit &gt; Format de cellule &gt; cat\u00e9gorie Personnalis\u00e9e et cr\u00e9ez le format personnalis\u00e9 suivant : [h]:mm<\/li>\n<li>Validez; ce format permet \u00e0 Excel de ne pas recommencer \u00e0 1 lorsqu&rsquo;il d\u00e9passe la 24\u00e8me heure<\/li>\n<\/ul>\n<p>PS : sur Mac, les symboles [ ] s&rsquo;obtiennent gr\u00e2ce aux touches Alt + 5 et Alt + 6<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez cr\u00e9\u00e9 un tableau comportant une colonne dans laquelle vous avez saisi des heures et des minutes (8:30, 7:20, 9:15&#8230; pour inscrire par ex. vos horaires&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3806,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[53,49],"class_list":{"0":"post-338","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-date","9":"tag-format"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=338"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/338\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3806"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}