{"id":1679,"date":"2023-11-11T16:25:01","date_gmt":"2023-11-11T16:25:01","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/"},"modified":"2023-12-06T05:57:28","modified_gmt":"2023-12-06T05:57:28","slug":"tijd-in-minuten-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/","title":{"rendered":"Hoe de waarde van tijd omzetten in minuten?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1140944660\"><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 minuten, moet je deze waarde vermenigvuldigen met 1440. Dit is het totale aantal minuten dat we op \u00e9\u00e9n dag hebben, en Excel slaat de tijd op als decimalen (1 is gelijk aan 24 uur). Wanneer u nu een tijdwaarde vermenigvuldigt met 1440 minuten, wordt het aantal minuten 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-79522\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-en-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"tijd-waarde-in-minuten\" width=\"553\" height=\"302\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Formule om tijd om te zetten in minuten<\/h2><p> U kunt de onderstaande stappen gebruiken:<\/p><ol type=\"1\"><li> Voer eerst de gelijkheidsoperator 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 1440 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-79523\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-convertir-le-temps-en-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"formule-om-tijd-naar-minuten om te zetten\" width=\"529\" height=\"288\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1*1440<\/code><\/pre><p> Zodra u de bovenstaande formule in een cel heeft ingevoerd, zou u de celopmaak <strong>&#8216;Algemeen<\/strong> &#8216; moeten hebben, zodat u het totale aantal minuten als getal in de cel kunt zien. <\/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=\"algemene opmaak op cel toepassen\" width=\"502\" height=\"299\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Converteer de totale tijd naar minuten<\/h2><p> Als u een tijdwaarde heeft die het totaal is van meerdere tijdwaarden, kunt u deze formule nog steeds gebruiken. <\/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=\"converteer de totale tijd naar minuten\" width=\"369\" height=\"321\"><\/figure><\/div><p> In cel A3 hebben we de som en in cel A5 hebben we dezelfde formule ingevoerd om het totale aantal minuten 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-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=\"totaal-minuten-sinds-tijd-waarde\" 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\"> 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-minutes.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-1679","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>Hoe de waarde van tijd omzetten in minuten? - Excel-adviseur<\/title>\n<meta name=\"description\" content=\"In deze tutorial leren we hoe we Excel-formules kunnen schrijven om de waarde van tijd 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-minuten-2\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe de waarde van tijd omzetten in minuten? - Excel-adviseur\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leren we hoe we Excel-formules kunnen schrijven om de waarde van tijd naar seconden om te zetten. Laten we dit controleren...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:57:28+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=\"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-minuten-2\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/\",\"name\":\"Hoe de waarde van tijd omzetten in minuten? - Excel-adviseur\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tijd-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-06T05:57:28+00:00\",\"description\":\"In deze tutorial leren we hoe we Excel-formules kunnen schrijven om de waarde van tijd naar seconden om te zetten. Laten we dit controleren...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tijd-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\/nl\/tijd-in-minuten-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe de waarde van tijd omzetten in minuten?\"}]},{\"@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":"Hoe de waarde van tijd omzetten in minuten? - Excel-adviseur","description":"In deze tutorial leren we hoe we Excel-formules kunnen schrijven om de waarde van tijd 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-minuten-2\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe de waarde van tijd omzetten in minuten? - Excel-adviseur","og_description":"In deze tutorial leren we hoe we Excel-formules kunnen schrijven om de waarde van tijd naar seconden om te zetten. Laten we dit controleren...","og_url":"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:57:28+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":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/","url":"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/","name":"Hoe de waarde van tijd omzetten in minuten? - Excel-adviseur","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/tijd-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-06T05:57:28+00:00","description":"In deze tutorial leren we hoe we Excel-formules kunnen schrijven om de waarde van tijd naar seconden om te zetten. Laten we dit controleren...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/tijd-in-minuten-2\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/tijd-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\/nl\/tijd-in-minuten-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe de waarde van tijd omzetten in minuten?"}]},{"@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\/1679","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=1679"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1679\/revisions"}],"predecessor-version":[{"id":2383,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1679\/revisions\/2383"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}