{"id":1582,"date":"2023-11-16T09:26:42","date_gmt":"2023-11-16T09:26:42","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/"},"modified":"2023-12-06T05:49:20","modified_gmt":"2023-12-06T05:49:20","slug":"militaire-tijd","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/","title":{"rendered":"Hoe kan ik standaardtijd omzetten in militaire tijd?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1330821773\"><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> <figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\"><\/div><\/figure><h2 class=\"wp-block-heading\"> Converteer standaardtijd naar militaire tijd<\/h2><p> U kunt de TEKST-functie gebruiken om standaardtijd om te zetten in militaire tijd in Excel. In het volgende voorbeeld hebben we de tijd in de cellen A1 en A2. De eerste keer is in de ochtend en de tweede in de middag. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64171\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-temps-normal.png\" sizes=\"auto, \" srcset=\"\" alt=\"convert-normale-tijd\" width=\"233\" height=\"146\"><\/figure><\/div><p> Met behulp van de tekstfunctie kunt u deze tijd nu omzetten in militaire tijd en de formule zou als volgt zijn. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1,\"HHMM\")<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64172\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-temps-militaire.png\" sizes=\"auto, \" srcset=\"\" alt=\"militaire tijd\" width=\"393\" height=\"149\"><\/figure><\/div><p> In het formaatargument heb je het formaat &#8220;UUMM&#8221;, dat zonder dubbele punt is en de tijd als militaire tijd weergeeft.<\/p><h2 class=\"wp-block-heading\"> Krijg militaire tijd met aangepaste opmaak<\/h2><p> Als u aangepaste opmaak wilt gebruiken, moet u de cel of het celbereik selecteren waar u de militaire tijd wilt verkrijgen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64173\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-heures-militaires-utilisant-un-formatage-personnalise.png\" sizes=\"auto, \" srcset=\"\" alt=\"militaire tijd met aangepaste opmaak\" width=\"490\" height=\"484\"><\/figure><\/div><ol type=\"1\"><li> Nadat u de cel hebt geselecteerd, gebruikt u de sneltoets Control + 1 om de opmaakopties te openen.<\/li><li> Klik op Aangepast om toegang te krijgen tot de optie voor aangepaste opmaak.<\/li><li> Van daaruit klikt u op het invoervak en het formaat dat u daar al hebt.<\/li><li> Voer aan het einde \u201cHHMM\u201d in als formaat en klik op OK. <\/li><\/ol><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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/temps-militaire-2.xlsx\" rel=\"nofollow\">Downloaden<\/a> <\/p><\/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><div class=\"wp-block-columns is-layout-flex wp-container-7\"><div class=\"wp-block-column is-layout-flow\"><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\/\">Verschil tussen twee keer 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\/aparte-datum-en-tijd-2\/\">Aparte datum en tijd in Excel<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tijd-in-seconden-2\/\">Converteer tijdwaarde naar seconden<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/huidige-tijd-2\/\">Krijg de huidige tijd (Excel-formule)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/slaaptijd-2\/\">Somtijd in Excel (Excel-formule)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-seconden-toe-aan-de-tijd\/\">Voeg seconden toe aan de tijd<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/seconden-tot-uren-minuten\/\">Converteer seconden naar uren en minuten<\/a><\/li><\/ul><\/div><\/div><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-1582","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 standaardtijd omzetten in militaire tijd?<\/title>\n<meta name=\"description\" content=\"In deze formule-tutorial leert u hoe u militaire tijd kunt verkrijgen en hoe u een standaardtijd in militaire tijd kunt formatteren met behulp van a\" \/>\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\/militaire-tijd\/\" \/>\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 standaardtijd omzetten in militaire tijd?\" \/>\n<meta property=\"og:description\" content=\"In deze formule-tutorial leert u hoe u militaire tijd kunt verkrijgen en hoe u een standaardtijd in militaire tijd kunt formatteren met behulp van a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:49:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-temps-normal.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\/militaire-tijd\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/\",\"name\":\"\u25b7 Hoe kan ik standaardtijd omzetten in militaire tijd?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-temps-normal.png\",\"datePublished\":\"2023-11-16T09:26:42+00:00\",\"dateModified\":\"2023-12-06T05:49:20+00:00\",\"description\":\"In deze formule-tutorial leert u hoe u militaire tijd kunt verkrijgen en hoe u een standaardtijd in militaire tijd kunt formatteren met behulp van a\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-temps-normal.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-temps-normal.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe kan ik standaardtijd omzetten in militaire tijd?\"}]},{\"@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 standaardtijd omzetten in militaire tijd?","description":"In deze formule-tutorial leert u hoe u militaire tijd kunt verkrijgen en hoe u een standaardtijd in militaire tijd kunt formatteren met behulp van a","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\/militaire-tijd\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe kan ik standaardtijd omzetten in militaire tijd?","og_description":"In deze formule-tutorial leert u hoe u militaire tijd kunt verkrijgen en hoe u een standaardtijd in militaire tijd kunt formatteren met behulp van a","og_url":"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:49:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-temps-normal.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\/militaire-tijd\/","url":"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/","name":"\u25b7 Hoe kan ik standaardtijd omzetten in militaire tijd?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-temps-normal.png","datePublished":"2023-11-16T09:26:42+00:00","dateModified":"2023-12-06T05:49:20+00:00","description":"In deze formule-tutorial leert u hoe u militaire tijd kunt verkrijgen en hoe u een standaardtijd in militaire tijd kunt formatteren met behulp van a","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/militaire-tijd\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-temps-normal.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-le-temps-normal.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/militaire-tijd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe kan ik standaardtijd omzetten in militaire tijd?"}]},{"@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\/1582","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=1582"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1582\/revisions"}],"predecessor-version":[{"id":2608,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1582\/revisions\/2608"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}