{"id":6665,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/minute\/"},"modified":"2021-02-26T08:10:24","modified_gmt":"2021-02-26T08:10:24","slug":"minute","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/minute\/","title":{"rendered":"MINUTE"},"content":{"rendered":"
\n

Pr\u00e9sentation de la fonction pour extraire des minutes<\/h2>\n

La fonction que nous examinons ici est essentielle pour la manipulation de donn\u00e9es temporelles dans Microsoft Excel et Google Sheets. Cette fonction est con\u00e7ue pour retourner la valeur de minute d’une expression de temps donn\u00e9e. Cela peut \u00eatre extr\u00eamement utile dans l’analyse de s\u00e9ries temporelles ou dans la gestion des horaires. <\/p>\n

Syntaxe g\u00e9n\u00e9rale<\/h2>\n

La syntaxe de base pour utiliser cette fonction dans les deux applications est la suivante : <\/p>\n

  MINUTE(heure) <\/code> <\/pre>\n
 heure<\/b> : Il s\u2019agit de l\u2019argument qui repr\u00e9sente l\u2019heure de laquelle les minutes doivent \u00eatre extraites. Cet argument peut \u00eatre une valeur de temps directe sous forme de texte (par exemple \u00ab\u00a015:30\u00a0\u00bb), une r\u00e9f\u00e9rence \u00e0 une cellule contenant une heure ou une expression retournant une valeur de temps. <\/p>\n
Exemples concrets d’utilisation<\/h2>\n
 Pour illustrer comment cette fonction peut \u00eatre utilis\u00e9e, voici quelques exemples : <\/p>\n
  1. MINUTE(\"13:45\") retournera 45 2. MINUTE(A1) o\u00f9 A1 contient 16:20 retournera 20 <\/code> <\/pre>\n
Sc\u00e9nario d’application pratique: Planification d’\u00e9v\u00e9nements<\/h2>\n
 Prenons l’exemple d’une organisation qui pr\u00e9pare un \u00e9v\u00e9nement et souhaite calculer le temps moyen de d\u00e9but des diff\u00e9rents segments en minutes. <\/p>\n
 Supposons que le planning est le suivant : <\/p>\n
    \n
  • Segment 1: 08:30<\/li>\n
  • Segment 2: 10:15<\/li>\n
  • Segment 3: 14:50<\/li>\n<\/ul>\n
     Pour calculer les minutes \u00e0 partir de chaque heure, proc\u00e9dez comme suit : <\/p>\n
      =MINUTE(\"08:30\") \/\/ retourne 30 =MINUTE(\"10:15\") \/\/ retourne 15 =MINUTE(\"14:50\") \/\/ retourne 50 <\/code> <\/pre>\n
     Avec ces valeurs, vous pouvez ensuite calculer le temps moyen en minutes pour le d\u00e9but des segments. <\/p>\n
    Sc\u00e9nario d’application pratique: Analyse du temps de travail<\/h2>\n
     Imaginons une entreprise qui a besoin de calculer le temps moyen de pause prise par ses employ\u00e9s. <\/p>\n
     Les donn\u00e9es sont les suivantes : <\/p>\n
      \n
    • Pause de l’employ\u00e9 A \u00e0 12:45<\/li>\n
    • Pause de l’employ\u00e9 B \u00e0 12:30<\/li>\n
    • Pause de l’employ\u00e9 C \u00e0 13:05<\/li>\n<\/ul>\n
       Pour obtenir les minutes pr\u00e9cises de chaque pause, vous pouvez utiliser cette fonction : <\/p>\n
        =MINUTE(\"12:45\") \/\/ retourne 45 =MINUTE(\"12:30\") \/\/ retourne 30 =MINUTE(\"13:05\") \/\/ retourne 5 <\/code> <\/pre>\n
       Ces informations peuvent \u00eatre utiles pour un contr\u00f4le pr\u00e9cis des horaires de pauses et leur impact potentiel sur la productivit\u00e9. <\/p>\n<\/article>\n","protected":false},"excerpt":{"rendered":"
      Convertit un num\u00e9ro de s\u00e9rie en minute<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[321],"tags":[],"class_list":["post-6665","post","type-post","status-publish","format-standard","hentry","category-date-et-heure"],"acf":[],"yoast_head":"\nFonction MINUTE dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MINUTE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/minute\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MINUTE dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MINUTE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/minute\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:10:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MINUTE dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/minute\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/minute\/\",\"name\":\"Fonction MINUTE dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:10:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MINUTE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/minute\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/minute\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/minute\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Date et heure\",\"item\":\"https:\/\/functiontranslator.com\/fr\/date-et-heure\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MINUTE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction MINUTE dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MINUTE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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:\/\/functiontranslator.com\/fr\/minute\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MINUTE dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MINUTE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/minute\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MINUTE dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/minute\/","url":"https:\/\/functiontranslator.com\/fr\/minute\/","name":"Fonction MINUTE dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:10:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MINUTE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/minute\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/minute\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/minute\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Date et heure","item":"https:\/\/functiontranslator.com\/fr\/date-et-heure\/"},{"@type":"ListItem","position":3,"name":"MINUTE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6665"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6665\/revisions"}],"predecessor-version":[{"id":29676,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6665\/revisions\/29676"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}