{"id":3197,"date":"2023-11-10T16:37:58","date_gmt":"2023-11-10T16:37:58","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/"},"modified":"2023-12-03T13:04:41","modified_gmt":"2023-12-03T13:04:41","slug":"zeit-in-sekunden-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/","title":{"rendered":"Wie rechnet man den zeitwert in sekunden um?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1779786718\"><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 Sekunden umzurechnen, m\u00fcssen Sie diesen Wert mit 86400 multiplizieren. Dies ist die Gesamtzahl der Sekunden, die wir an einem einzelnen Tag haben, und Excel speichert die Zeit als Dezimalzahlen (1 entspricht 24 Stunden). Wenn Sie nun die Zeit mit der Gesamtzahl der Sekunden multiplizieren, wird die Anzahl der Sekunden 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-79546\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-valeurs-de-temps-en-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"Konvertieren Sie Zeitwerte in Sekunden\" width=\"518\" height=\"292\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Formel zur Umrechnung von Zeit in Sekunden<\/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 86400 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-79547\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-convertir-le-temps-en-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"Formel zur Umrechnung von Zeit in Sekunden\" width=\"551\" height=\"264\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1*86400<\/code><\/pre><p> Sobald Sie die obige Formel in eine Zelle eingeben, m\u00fcssen Sie das Zellenformat \u201e <strong>Allgemein<\/strong> \u201c haben, damit Sie den numerischen Wert 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-79548\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-la-mise-en-forme-generale-a-la-cellule-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"Allgemeine Formatierung auf Zelle anwenden\" width=\"624\" height=\"311\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Konvertieren Sie die Gesamtzeit in Sekunden<\/h2><p> Wenn Sie einen Zeitwert haben, der die Summe mehrerer Zeitwerte darstellt, k\u00f6nnen Sie dennoch dieselbe Formel verwenden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79549\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-convertir-le-temps-total-en-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"Konvertieren Sie die Gesamtzeit in Sekunden\" width=\"395\" height=\"355\"><\/figure><\/div><p> In Zelle A3 haben wir die Summe und in Zelle A5 haben wir dieselbe Formel verwendet, um aus dem Zeitwert die Gesamtzahl der Sekunden zu ermitteln. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79550\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-secondes-au-total-a-partir-de-la-valeur-de-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"Gesamtwert der Sekunden seit der Zeit\" width=\"350\" height=\"382\"><\/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-secondes.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 (erhalten 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-3197","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>\u25b7 Wie rechnet man den Zeitwert in Sekunden um?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial lernen wir, wie man eine Excel-Formel schreibt, um einen Zeitwert in Sekunden umzuwandeln. 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-sekunden-2\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Wie rechnet man den Zeitwert in Sekunden um?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial lernen wir, wie man eine Excel-Formel schreibt, um einen Zeitwert in Sekunden umzuwandeln. Lassen Sie uns das \u00fcberpr\u00fcfen ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:04:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-valeurs-de-temps-en-secondes.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-sekunden-2\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/\",\"name\":\"\u25b7 Wie rechnet man den Zeitwert in Sekunden um?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-valeurs-de-temps-en-secondes.png\",\"datePublished\":\"2023-11-10T16:37:58+00:00\",\"dateModified\":\"2023-12-03T13:04:41+00:00\",\"description\":\"In diesem Tutorial lernen wir, wie man eine Excel-Formel schreibt, um einen Zeitwert in Sekunden umzuwandeln. Lassen Sie uns das \u00fcberpr\u00fcfen ...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-valeurs-de-temps-en-secondes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-valeurs-de-temps-en-secondes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-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 sekunden 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":"\u25b7 Wie rechnet man den Zeitwert in Sekunden um?","description":"In diesem Tutorial lernen wir, wie man eine Excel-Formel schreibt, um einen Zeitwert in Sekunden umzuwandeln. 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-sekunden-2\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie rechnet man den Zeitwert in Sekunden um?","og_description":"In diesem Tutorial lernen wir, wie man eine Excel-Formel schreibt, um einen Zeitwert in Sekunden umzuwandeln. Lassen Sie uns das \u00fcberpr\u00fcfen ...","og_url":"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:04:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-valeurs-de-temps-en-secondes.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-sekunden-2\/","url":"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/","name":"\u25b7 Wie rechnet man den Zeitwert in Sekunden um?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-valeurs-de-temps-en-secondes.png","datePublished":"2023-11-10T16:37:58+00:00","dateModified":"2023-12-03T13:04:41+00:00","description":"In diesem Tutorial lernen wir, wie man eine Excel-Formel schreibt, um einen Zeitwert in Sekunden umzuwandeln. Lassen Sie uns das \u00fcberpr\u00fcfen ...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-valeurs-de-temps-en-secondes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-valeurs-de-temps-en-secondes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/zeit-in-sekunden-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 sekunden 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\/3197","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=3197"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3197\/revisions"}],"predecessor-version":[{"id":4171,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3197\/revisions\/4171"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}