{"id":3170,"date":"2023-11-11T16:25:01","date_gmt":"2023-11-11T16:25:01","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/"},"modified":"2023-12-03T13:04:40","modified_gmt":"2023-12-03T13:04:40","slug":"zeit-in-minuten-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/","title":{"rendered":"Wie rechnet man den zeitwert in minuten um?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-4163598248\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Um eine Stunde in Excel in Minuten umzurechnen, m\u00fcssen Sie diesen Wert mit 1440 multiplizieren. Dies ist die Gesamtzahl der Minuten, die wir an einem einzelnen Tag haben, und Excel speichert die Zeit als Dezimalzahlen (1 entspricht 24 Stunden). Wenn Sie nun einen Zeitwert mit 1440 Minuten multiplizieren, wird die Anzahl der Minuten basierend auf dieser Zeit zur\u00fcckgegeben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79522\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"Zeitwert in Minuten\" width=\"553\" height=\"302\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Formel zur Umrechnung von Zeit in Minuten<\/h2><p> Sie k\u00f6nnen die folgenden Schritte ausf\u00fchren:<\/p><ol type=\"1\"><li> Geben Sie zun\u00e4chst den Gleichheitsoperator ein.<\/li><li> Schauen Sie sich als N\u00e4chstes die Zelle an, in der Sie den Zeitwert haben.<\/li><li> Geben Sie nun zum Multiplizieren das Sternchen ein.<\/li><li> Geben Sie danach 1440 ein.<\/li><li> Dr\u00fccken Sie am Ende die Eingabetaste, um das Ergebnis zu erhalten. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79523\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-convertir-le-temps-en-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"Formel zur Umrechnung von Zeit in Minuten\" width=\"529\" height=\"288\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1*1440<\/code><\/pre><p> Sobald Sie die obige Formel in eine Zelle eingegeben haben, sollte das Zellenformat <strong>\u201eAllgemein<\/strong> \u201c vorliegen, damit Sie die Gesamtzahl der Minuten als Zahl in der Zelle haben k\u00f6nnen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79524\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-la-mise-en-forme-generale-a-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"Allgemeine Formatierung auf Zelle anwenden\" width=\"502\" height=\"299\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Konvertieren Sie die Gesamtzeit in Minuten<\/h2><p> Wenn Sie einen Zeitwert haben, der die Summe mehrerer Zeitwerte darstellt, k\u00f6nnen Sie diese Formel trotzdem verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79525\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-convertir-le-temps-total-en-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"Konvertieren Sie die Gesamtzeit in Minuten\" width=\"369\" height=\"321\"><\/figure><\/div><p> In Zelle A3 haben wir die Summe und in Zelle A5 haben wir die gleiche Formel eingegeben, um aus dem Zeitwert die Gesamtzahl der Minuten zu ermitteln. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79526\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-minutes-au-total-a-partir-de-la-valeur-de-temps1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Gesamtminuten seit Zeitwert\" width=\"387\" height=\"375\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Holen Sie sich die Excel-Datei<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/temps-en-minutes.xlsx\" rel=\"nofollow\">Herunterladen<\/a> <\/div><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Weitere Formeln<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/fugen-sie-stunden-hinzu\/\">Addieren Sie Stunden zur Zeit in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/fugen-sie-der-zeit-minuten-hinzu\/\">Addieren Sie Minuten zur Zeit in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/zeitunterschied-berechnen\/\">Berechnen Sie den Zeitunterschied zwischen zwei Stunden in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/zeitformat-andern\/\">Zeitformat in Excel \u00e4ndern<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/wehrdienst\/\">Milit\u00e4rzeit (Get und Subtrahieren) in Excel<\/a><\/li><\/ul><p> \u21e0 Zur\u00fcck zur <a href=\"https:\/\/exceladvisor.org\/de\/formeln\/\">Liste mit \u00fcber 100 Excel-Formeln (Grundkenntnisse + Fortgeschrittene)<\/a><\/p><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3170","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Wie rechnet man den Zeitwert in Minuten um? - Excel-Berater<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial lernen wir, wie man Excel-Formeln schreibt, um den Zeitwert in Sekunden umzurechnen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie rechnet man den Zeitwert in Minuten um? - Excel-Berater\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial lernen wir, wie man Excel-Formeln schreibt, um den Zeitwert in Sekunden umzurechnen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:04:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/\",\"name\":\"Wie rechnet man den Zeitwert in Minuten um? - Excel-Berater\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png\",\"datePublished\":\"2023-11-11T16:25:01+00:00\",\"dateModified\":\"2023-12-03T13:04:40+00:00\",\"description\":\"In diesem Tutorial lernen wir, wie man Excel-Formeln schreibt, um den Zeitwert in Sekunden umzurechnen. Lassen Sie uns das \u00fcberpr\u00fcfen ...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie rechnet man den zeitwert in minuten um?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie rechnet man den Zeitwert in Minuten um? - Excel-Berater","description":"In diesem Tutorial lernen wir, wie man Excel-Formeln schreibt, um den Zeitwert in Sekunden umzurechnen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","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:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/","og_locale":"de_DE","og_type":"article","og_title":"Wie rechnet man den Zeitwert in Minuten um? - Excel-Berater","og_description":"In diesem Tutorial lernen wir, wie man Excel-Formeln schreibt, um den Zeitwert in Sekunden umzurechnen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","og_url":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:04:40+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/","url":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/","name":"Wie rechnet man den Zeitwert in Minuten um? - Excel-Berater","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png","datePublished":"2023-11-11T16:25:01+00:00","dateModified":"2023-12-03T13:04:40+00:00","description":"In diesem Tutorial lernen wir, wie man Excel-Formeln schreibt, um den Zeitwert in Sekunden umzurechnen. Lassen Sie uns das \u00fcberpr\u00fcfen ...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/zeit-in-minuten-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie rechnet man den zeitwert in minuten um?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3170"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3170\/revisions"}],"predecessor-version":[{"id":4170,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3170\/revisions\/4170"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}