{"id":1706,"date":"2023-11-10T16:37:58","date_gmt":"2023-11-10T16:37:58","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/"},"modified":"2023-12-06T05:56:54","modified_gmt":"2023-12-06T05:56:54","slug":"tijd-in-seconden-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/","title":{"rendered":"Hoe converteer je de waarde van tijd naar seconden?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3206843463\"><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>Om een uur in Excel om te rekenen naar seconden, moet je deze waarde vermenigvuldigen met 86400. Dit is het totale aantal seconden dat we op \u00e9\u00e9n dag hebben, en Excel slaat de tijd op als decimalen (1 is gelijk aan 24 uur). Wanneer u nu de tijd vermenigvuldigt met het totale aantal seconden, wordt het aantal seconden geretourneerd op basis van die tijd. <\/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=\"converteer tijdwaarden naar seconden\" width=\"518\" height=\"292\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Formule om tijd om te zetten in seconden<\/h2><p> U kunt de onderstaande stappen gebruiken:<\/p><ol type=\"1\"><li> Voer eerst de gelijk-operator (=) in.<\/li><li> Raadpleeg vervolgens de cel waar u de tijdswaarde hebt.<\/li><li> Voer nu het sterretje in om te vermenigvuldigen.<\/li><li> Voer daarna 86400 in.<\/li><li> Druk aan het einde op Enter om het resultaat te krijgen. <\/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=\"formule-om-tijd-naar-seconden om te zetten\" width=\"551\" height=\"264\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1*86400<\/code><\/pre><p> Zodra u de bovenstaande formule in een cel invoert, moet u de celopmaak &#8216; <strong>Algemeen<\/strong> &#8216; hebben, zodat u de numerieke waarde in de cel kunt weergeven. <\/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=\"algemene opmaak op cel toepassen\" width=\"624\" height=\"311\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Converteer de totale tijd naar seconden<\/h2><p> Als u een tijdwaarde hebt die het totaal is van meerdere tijdwaarden, kunt u nog steeds dezelfde formule gebruiken. <\/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=\"converteer de totale tijd naar seconden\" width=\"395\" height=\"355\"><\/figure><\/div><p> In cel A3 hebben we de som en in cel A5 gebruikten we dezelfde formule om het totale aantal seconden uit de tijdswaarde te halen. <\/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=\"totale-seconden-sinds-tijd-waarde\" 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\"> Haal het Excel-bestand op<\/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\">Downloaden<\/a> <\/div><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Meer formules<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/uren-toevoegen\/\">Voeg uren toe aan tijd in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/minuten-toevoegen-aan-de-tijd\/\">Voeg minuten toe aan tijd in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tijdsverschil-berekenen\/\">Bereken het tijdsverschil tussen twee uur in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tijdformaat-wijzigen\/\">Wijzig het tijdformaat in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/\">Militaire tijd (ophalen en aftrekken) in Excel<\/a><\/li><\/ul><p> \u21e0 Terug naar <a href=\"https:\/\/exceladvisor.org\/nl\/formules\/\">lijst met meer dan 100 Excel-formules (basis + geavanceerd)<\/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-1706","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 Hoe kan ik de waarde van tijd omzetten in seconden?<\/title>\n<meta name=\"description\" content=\"In deze tutorial leren we hoe we een Excel-formule kunnen schrijven om een tijdswaarde naar seconden om te zetten. Laten we dit controleren...\" \/>\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\/nl\/tijd-in-seconden-2\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe kan ik de waarde van tijd omzetten in seconden?\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leren we hoe we een Excel-formule kunnen schrijven om een tijdswaarde naar seconden om te zetten. Laten we dit controleren...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:56:54+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=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/\",\"name\":\"\u25b7 Hoe kan ik de waarde van tijd omzetten in seconden?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-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-06T05:56:54+00:00\",\"description\":\"In deze tutorial leren we hoe we een Excel-formule kunnen schrijven om een tijdswaarde naar seconden om te zetten. Laten we dit controleren...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-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\/nl\/tijd-in-seconden-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe converteer je de waarde van tijd naar seconden?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Hoe kan ik de waarde van tijd omzetten in seconden?","description":"In deze tutorial leren we hoe we een Excel-formule kunnen schrijven om een tijdswaarde naar seconden om te zetten. Laten we dit controleren...","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\/nl\/tijd-in-seconden-2\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe kan ik de waarde van tijd omzetten in seconden?","og_description":"In deze tutorial leren we hoe we een Excel-formule kunnen schrijven om een tijdswaarde naar seconden om te zetten. Laten we dit controleren...","og_url":"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:56:54+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":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/","url":"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/","name":"\u25b7 Hoe kan ik de waarde van tijd omzetten in seconden?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-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-06T05:56:54+00:00","description":"In deze tutorial leren we hoe we een Excel-formule kunnen schrijven om een tijdswaarde naar seconden om te zetten. Laten we dit controleren...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-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\/nl\/tijd-in-seconden-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe converteer je de waarde van tijd naar seconden?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1706","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1706"}],"version-history":[{"count":2,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1706\/revisions"}],"predecessor-version":[{"id":3082,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1706\/revisions\/3082"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}