{"id":4923,"date":"2023-07-06T09:14:08","date_gmt":"2023-07-06T09:14:08","guid":{"rendered":"https:\/\/statorials.org\/id\/hitung-mundur-excel\/"},"modified":"2023-07-06T09:14:08","modified_gmt":"2023-07-06T09:14:08","slug":"hitung-mundur-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/hitung-mundur-excel\/","title":{"rendered":"Cara membuat penghitung waktu mundur di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat membuat penghitung waktu mundur di Excel yang menghitung jumlah hari, jam, dan menit hingga suatu tanggal menggunakan fungsi <strong>SEKARANG()<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini untuk membuat penghitung waktu mundur dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan tanggal hitung mundur<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah hari ini <strong>18\/07\/2023<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Saya akan membuat penghitung waktu mundur di Excel yang menghitung jumlah hari, jam, menit dan detik hingga <strong>01\/08\/2023<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38430 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-reboursexcel1.png\" alt=\"\" width=\"481\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Rumus untuk Hitung Mundur<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa menggunakan rumus berikut untuk menghitung jumlah hari, jam, menit dan detik hingga 01\/08\/2023:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Hari<\/strong> : =INT(A2-SEKARANG())<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jam<\/strong> : =JAM(A2-SEKARANG())<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Menit<\/strong> : =MENIT(A2-SEKARANG())<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Detik<\/strong> : =SECOND(A2-NOW())<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat mengetikkan rumus ini ke dalam masing-masing selnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38431\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-reboursexcel2.png\" alt=\"Hitung Mundur Excel\" width=\"671\" height=\"291\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Artinya tanggal 18\/8\/2023 berjarak <strong>13<\/strong> hari, <strong>14<\/strong> jam, <b>23<\/b> menit, dan <strong>11<\/strong> detik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Perbarui Penghitung Waktu Mundur Secara Manual<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk memperbarui hitungan mundur, cukup klik dua kali sel mana pun di lembar bentang Excel lalu tekan <strong>Enter<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hitung mundur akan secara otomatis memperbarui nilai hari, jam, menit dan detik segera setelah Anda menekan <strong>Enter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38432 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-reboursexcel3.png\" alt=\"\" width=\"669\" height=\"293\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Perbarui Penghitung Waktu Mundur Secara Otomatis (Opsional)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Jika Anda ingin hitungan mundur diperbarui secara otomatis pada interval tertentu, Anda perlu menulis beberapa kode sederhana di VBA.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebelum melakukannya, kita perlu memastikan bahwa tab <strong>Pengembang<\/strong> terlihat di pita atas Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik tab <strong>File<\/strong> , lalu <strong>Opsi<\/strong> , lalu <strong>Sesuaikan Pita<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di bawah bagian berjudul <strong>Main Tabs<\/strong> , centang kotak di samping <strong>Developer<\/strong> , lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34809 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc1.png\" alt=\"\" width=\"698\" height=\"544\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Pengembang<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Visual Basic<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34811 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc3.png\" alt=\"\" width=\"640\" height=\"197\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Modul<\/strong> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34812 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sc4.png\" alt=\"\" width=\"513\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, tempelkan kode berikut ke dalam editor kode modul:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #3366ff;\">Sub<\/span> UpdateCountdown()\n\nRange(\"C2:F2\").Calculate\nApplication.OnTime DateAdd(\"s\", 1, Now), \"UpdateCountdown\"\n\n<span style=\"color: #3366ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik panah Play kecil berwarna hijau untuk menjalankan kode VBA ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38434 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-reboursexcel4.png\" alt=\"\" width=\"602\" height=\"391\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda memasukkan kode, silakan tutup editor VB. Kode akan disimpan secara otomatis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai hari, jam, menit, dan detik kini akan diperbarui secara otomatis setiap detik di spreadsheet.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/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\">Excel: cara mengurangi menit dari waktu<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengekstrak-waktu-dari-datetime\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengekstrak waktu dari Datetime<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/format-cap-waktu-excel-milidetik\/\" target=\"_blank\" rel=\"noopener\">Excel: cara memformat waktu dalam milidetik<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat membuat penghitung waktu mundur di Excel yang menghitung jumlah hari, jam, dan menit hingga suatu tanggal menggunakan fungsi SEKARANG() . Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi ini untuk membuat penghitung waktu mundur dalam praktiknya. Langkah 1: Masukkan tanggal hitung mundur Katakanlah hari ini 18\/07\/2023 . Saya akan membuat penghitung waktu [&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>Cara Membuat Penghitung Waktu Mundur di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Excel, dengan contoh lengkap.\" \/>\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\/hitung-mundur-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Penghitung Waktu Mundur di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/hitung-mundur-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T09:14:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-reboursexcel1.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\/hitung-mundur-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/hitung-mundur-excel\/\",\"name\":\"Cara Membuat Penghitung Waktu Mundur di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T09:14:08+00:00\",\"dateModified\":\"2023-07-06T09:14:08+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/hitung-mundur-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/hitung-mundur-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/hitung-mundur-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat penghitung waktu mundur di excel\"}]},{\"@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":"Cara Membuat Penghitung Waktu Mundur di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Excel, dengan contoh lengkap.","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\/hitung-mundur-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Penghitung Waktu Mundur di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/hitung-mundur-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-06T09:14:08+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-reboursexcel1.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\/hitung-mundur-excel\/","url":"https:\/\/statorials.org\/id\/hitung-mundur-excel\/","name":"Cara Membuat Penghitung Waktu Mundur di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T09:14:08+00:00","dateModified":"2023-07-06T09:14:08+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/hitung-mundur-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/hitung-mundur-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/hitung-mundur-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat penghitung waktu mundur di excel"}]},{"@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\/4923"}],"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=4923"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4923\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}