{"id":4933,"date":"2023-07-06T06:03:40","date_gmt":"2023-07-06T06:03:40","guid":{"rendered":"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/"},"modified":"2023-07-06T06:03:40","modified_gmt":"2023-07-06T06:03:40","slug":"unggul-waktu-militer-ke-waktu-standar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/","title":{"rendered":"Excel: konversi antara waktu standar &amp; waktu militer"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk mengonversi antara waktu standar dan waktu militer di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Formula 1: Ubah Waktu Standar menjadi Waktu Militer<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A2<\/span> ,\"HHMM\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengubah waktu standar di sel <strong>A2<\/strong> menjadi waktu militer.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Ubah Waktu Militer menjadi Waktu Standar<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TIMEVALUE(LEFT( <span style=\"color: #3366ff;\">A2,2<\/span> )&amp;\":\"&amp;RIGHT( <span style=\"color: #3366ff;\">A2,2<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengubah waktu militer di sel <strong>A2<\/strong> menjadi waktu standar.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Ubah Waktu Standar menjadi Waktu Militer<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Misalkan kita memiliki daftar waktu standar berikut di Excel:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38507 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laitance1.png\" alt=\"\" width=\"461\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengubah waktu standar menjadi waktu militer:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A2<\/span> ,\"HHMM\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38506\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laitance2.png\" alt=\"Excel mengubah waktu standar menjadi waktu militer\" width=\"477\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan setiap waktu standar di kolom A sebagai waktu militer.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda juga ingin menampilkan detik dalam waktu militer, Anda dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXT( <span style=\"color: #3366ff;\">A2<\/span> ,\"HHMMSS\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38508 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laitance3.png\" alt=\"\" width=\"475\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Ubah waktu militer menjadi waktu standar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar jam militer berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38510 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laitance4.png\" alt=\"\" width=\"477\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk mengubah waktu militer menjadi waktu standar:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TIMEVALUE(LEFT( <span style=\"color: #3366ff;\">A2,2<\/span> )&amp;\":\"&amp;RIGHT( <span style=\"color: #3366ff;\">A2,2<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38511 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laitance5.png\" alt=\"\" width=\"539\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, waktu di kolom B ditampilkan dalam bentuk desimal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memformat tempat desimal ini sebagai jam, sorot rentang sel <strong>B2:B10<\/strong> , lalu klik daftar drop-down <strong>Format Angka<\/strong> pada tab <strong>Beranda<\/strong> , lalu klik <strong>Waktu<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38512 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lait6.png\" alt=\"\" width=\"475\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang akan menampilkan setiap waktu militer di kolom A sebagai waktu standar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38513\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laitance7.png\" alt=\"Excel mengubah waktu militer menjadi waktu standar\" width=\"477\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-kurangi-menit-dari-waktu\/\" target=\"_blank\" rel=\"noopener\">Cara mengurangi menit dari waktu di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/format-cap-waktu-excel-milidetik\/\" target=\"_blank\" rel=\"noopener\">Cara Memformat Waktu dalam Milidetik di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengekstrak-waktu-dari-datetime\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak waktu dari tanggal dan waktu di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk mengonversi antara waktu standar dan waktu militer di Excel: Formula 1: Ubah Waktu Standar menjadi Waktu Militer =TEXT( A2 ,&#8221;HHMM&#8221;) Rumus khusus ini mengubah waktu standar di sel A2 menjadi waktu militer. Rumus 2: Ubah Waktu Militer menjadi Waktu Standar =TIMEVALUE(LEFT( A2,2 )&amp;&#8221;:&#8221;&amp;RIGHT( A2,2 )) Rumus khusus ini mengubah [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Konversi antara Waktu Standar dan Waktu Militer - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah waktu standar dan waktu militer di Excel, beserta contohnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Konversi antara Waktu Standar dan Waktu Militer - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah waktu standar dan waktu militer di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T06:03:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laitance1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/\",\"url\":\"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/\",\"name\":\"Excel: Konversi antara Waktu Standar dan Waktu Militer - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T06:03:40+00:00\",\"dateModified\":\"2023-07-06T06:03:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah waktu standar dan waktu militer di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: konversi antara waktu standar &amp; waktu militer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Konversi antara Waktu Standar dan Waktu Militer - Statologi","description":"Tutorial ini menjelaskan cara mengubah waktu standar dan waktu militer di Excel, beserta contohnya.","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:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Konversi antara Waktu Standar dan Waktu Militer - Statologi","og_description":"Tutorial ini menjelaskan cara mengubah waktu standar dan waktu militer di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/","og_site_name":"Statorials","article_published_time":"2023-07-06T06:03:40+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/laitance1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/","url":"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/","name":"Excel: Konversi antara Waktu Standar dan Waktu Militer - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T06:03:40+00:00","dateModified":"2023-07-06T06:03:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah waktu standar dan waktu militer di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/unggul-waktu-militer-ke-waktu-standar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: konversi antara waktu standar &amp; waktu militer"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4933"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4933"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4933\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}