{"id":716,"date":"2023-05-18T07:52:00","date_gmt":"2023-05-18T05:52:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=716"},"modified":"2023-06-21T19:23:58","modified_gmt":"2023-06-21T17:23:58","slug":"separer-date-et-heure-avec-excel","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/","title":{"rendered":"Comment s\u00e9parer la date et l’heure avec Excel dans deux colonnes diff\u00e9rentes ?"},"content":{"rendered":"\n

Tutoriel Excel pour s\u00e9parer la date et l’heure dans 2 colonnes distinctes.<\/em><\/strong><\/h4>\n\n\n\n

Comment s\u00e9parer date et heure avec Excel, pour obtenir deux colonnes ind\u00e9pendantes ? Diviser une date de l’heure avec Excel n’est pas aussi simple que cela. Nous allons voir comment faire avec un exemple pratique sur Excel. En effet, souvent en travaillant avec Excel, les colonnes Dates contiennent en pratique le format \u00ab\u00a0Timestamp\u00a0\u00bb qui correspond en Fran\u00e7ais au format \u00ab\u00a0Date-Heure\u00a0\u00bb.<\/p>\n\n\n\n

Cependant pour effectuer des calculs sur les heures ou sur les jours il est plus pratique de scinder les dates et les heures. Par exemple, pour trouver une diff\u00e9rence de temps entre 2 horaires il est plus simple de manipuler les heures seules. Il existe de nombreuses formules Excel pour g\u00e9rer les dates et extraire chaque \u00e9l\u00e9ment comme ANNEE(), MOIS(), JOUR() par exemple. Cr\u00e9er tout d’abord les deux colonnes Excel de destination pour la date et l’heure.<\/p>\n\n\n\n

1. Pr\u00e9parer la colonne Date seule \u00e0 s\u00e9parer de l’heure<\/h2>\n\n\n\n

Premi\u00e8rement, remplir la colonne de type Date, nomm\u00e9e \u00ab\u00a0Date seule\u00a0\u00bb, comme dans l\u2019exemple ci-dessous:<\/p>\n\n\n\n

    \n
  1. Saisir la formule =ENT(A2)<\/strong><\/li>\n\n\n\n
  2. Assigner le Format Date<\/b> \u00e0 la colonne Date seule<\/em>.<\/li>\n<\/ol>\n\n\n\n

    La fonction Excel ENT()<\/strong> signifie Entier, \u00e0 appliquer \u00e0 votre premi\u00e8re cellule, ici en position A2<\/strong>, contenant la Date et l’Heure \u00e0 s\u00e9parer.<\/p>\n\n\n

    \n
    \"Les<\/figure><\/div>\n\n\n

    2. Pr\u00e9parer la colonne Heure seule \u00e0 s\u00e9parer de la date<\/h2>\n\n\n\n

    Deuxi\u00e8mement,  pr\u00e9parer la colonne \u00ab\u00a0Heure seule\u00a0\u00bb dans notre fichier Excel. Utiliser pour cela la fonction Excel MOD()<\/strong>, pour le Modulo<\/a> en math\u00e9matique:<\/p>\n\n\n\n

      \n
    1. Saisir la formule =MOD(A2;1)<\/b><\/li>\n\n\n\n
    2. Assigner le Format Heure<\/b> \u00e0 la colonne Heure seule<\/em>.<\/li>\n<\/ol>\n\n\n
      \n
      \"\"<\/figure><\/div>\n\n\n

      3. Le r\u00e9sultat apr\u00e8s avoir s\u00e9par\u00e9 la date et l’heure en 2 colonnes<\/h2>\n\n\n\n

      Enfin, observer le r\u00e9sultat avec les deux colonnes Date seule<\/em><\/strong> et Heure seule<\/em><\/strong> parfaitement s\u00e9par\u00e9es dans Excel avec respectivement un format Date et un format Heure.<\/p>\n\n\n

      \n
      \"\"<\/figure><\/div>\n\n\n

      Conclusion sur la s\u00e9paration de l’heure et de la date dans Excel<\/h3>\n\n\n\n

      Finalement, ce tutoriel explique pas \u00e0 pas comment s\u00e9parer date et heure avec les formules Excel et assigner le bon format d’affichage. Pour aller encore plus loin il est int\u00e9ressant de voir comment calculer les diff\u00e9rences jusqu’aux secondes \u00e0 partir de deux dates avec un format Date \/ Heure \/ Secondes, voici un exemple ici en langage SQL<\/a>. Plus d\u2019informations sur la page de la fonction MOD<\/a> sur le site de Microsoft.<\/p>\n\n\n\n

      \nhttps:\/\/expert-only.com\/fr\/t-sql\/difference-entre-deux-dates-sql-server\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"

      Tutoriel Excel pour s\u00e9parer la date et l’heure dans 2 colonnes distinctes. Comment s\u00e9parer date et heure avec Excel, pour obtenir deux colonnes ind\u00e9pendantes ? Diviser une date de l’heure avec Excel n’est pas aussi simple que cela. Nous …<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10372,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":{"0":"post-716","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel"},"yoast_head":"\nS\u00e9parer date et heure avec Excel - Astuces Excel<\/title>\n<meta name=\"description\" content=\"S\u00e9parer la date et l'heure avec Excel avec les fonctions et les formats de date et d'heure adapt\u00e9s dans des colonnes distinctes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment s\u00e9parer la date et l'heure avec Excel dans deux colonnes diff\u00e9rentes ?\" \/>\n<meta property=\"og:description\" content=\"S\u00e9parer la date et l'heure avec Excel avec les fonctions et les formats de date et d'heure adapt\u00e9s dans des colonnes distinctes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-18T05:52:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-21T17:23:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment s\u00e9parer la date et l’heure avec Excel dans deux colonnes diff\u00e9rentes ?\",\"datePublished\":\"2023-05-18T05:52:00+00:00\",\"dateModified\":\"2023-06-21T17:23:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/\"},\"wordCount\":428,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg\",\"articleSection\":[\"Astuces Excel\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/\",\"url\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/\",\"name\":\"S\u00e9parer date et heure avec Excel - Astuces Excel\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg\",\"datePublished\":\"2023-05-18T05:52:00+00:00\",\"dateModified\":\"2023-06-21T17:23:58+00:00\",\"description\":\"S\u00e9parer la date et l'heure avec Excel avec les fonctions et les formats de date et d'heure adapt\u00e9s dans des colonnes distinctes.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment s\u00e9parer la date et l’heure avec Excel dans deux colonnes diff\u00e9rentes ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"S\u00e9parer date et heure avec Excel - Astuces Excel","description":"S\u00e9parer la date et l'heure avec Excel avec les fonctions et les formats de date et d'heure adapt\u00e9s dans des colonnes distinctes.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment s\u00e9parer la date et l'heure avec Excel dans deux colonnes diff\u00e9rentes ?","og_description":"S\u00e9parer la date et l'heure avec Excel avec les fonctions et les formats de date et d'heure adapt\u00e9s dans des colonnes distinctes.","og_url":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-05-18T05:52:00+00:00","article_modified_time":"2023-06-21T17:23:58+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment s\u00e9parer la date et l’heure avec Excel dans deux colonnes diff\u00e9rentes ?","datePublished":"2023-05-18T05:52:00+00:00","dateModified":"2023-06-21T17:23:58+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/"},"wordCount":428,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg","articleSection":["Astuces Excel"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/","url":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/","name":"S\u00e9parer date et heure avec Excel - Astuces Excel","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg","datePublished":"2023-05-18T05:52:00+00:00","dateModified":"2023-06-21T17:23:58+00:00","description":"S\u00e9parer la date et l'heure avec Excel avec les fonctions et les formats de date et d'heure adapt\u00e9s dans des colonnes distinctes.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/calendar-660670_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/excel\/separer-date-et-heure-avec-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment s\u00e9parer la date et l’heure avec Excel dans deux colonnes diff\u00e9rentes ?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=716"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/716\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10372"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}