{"id":2735,"date":"2023-07-20T23:04:15","date_gmt":"2023-07-20T23:04:15","guid":{"rendered":"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/"},"modified":"2023-07-20T23:04:15","modified_gmt":"2023-07-20T23:04:15","slug":"hitung-mundur-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/","title":{"rendered":"Cara membuat penghitung waktu mundur di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat membuat penghitung waktu mundur di Google Spreadsheet 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<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan tanggal hitung mundur<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah hari ini <strong>03\/02\/2022<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Saya akan membuat penghitung waktu mundur di Google Sheets yang menghitung jumlah hari, jam, dan menit hingga <strong>02\/10\/2022<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24085 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-rebours1.jpg\" alt=\"\" width=\"505\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Rumus untuk Hitung Mundur<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa menggunakan rumus berikut untuk menghitung jumlah hari, jam dan menit hingga 02\/10\/2022:<\/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<\/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-24086\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-rebours2.jpg\" alt=\"hitung mundur di Google Spreadsheet\" width=\"630\" height=\"397\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa tanggal 02\/10\/22 berjarak <strong>6<\/strong> hari, <strong>12<\/strong> jam, dan <strong>42<\/strong> menit.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Perbarui hitungan mundur setiap menit<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk memastikan nilai hitung mundur diperbarui setiap menit, klik tab <strong>File<\/strong> di sepanjang pita atas, lalu klik <strong>Pengaturan<\/strong> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24087 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-rebours3.jpg\" alt=\"\" width=\"406\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Perhitungan<\/strong> , lalu klik panah drop-down di sebelah <strong>Perhitungan Ulang<\/strong> dan pilih <strong>Pada perubahan dan setiap menit<\/strong> , lalu klik <strong>Simpan pengaturan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24088 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-rebours4-1.jpg\" alt=\"\" width=\"573\" height=\"357\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hitung mundur sekarang akan secara otomatis memperbarui nilai hari, jam, dan menit setiap menit.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara Membandingkan Tanggal di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menambahkan-bulan-hingga-saat-ini\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan bulan hingga saat ini di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-tanggal-sumif-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan SUMIFS dengan rentang tanggal di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-tanggal-countifs-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIFS dengan rentang tanggal di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat membuat penghitung waktu mundur di Google Spreadsheet 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 03\/02\/2022 . Saya akan membuat penghitung [&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 Google Sheets \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Google Sheets, 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-google-sheet\/\" \/>\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 Google Sheets \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Google Sheets, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T23:04:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-rebours1.jpg\" \/>\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=\"1 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-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/\",\"name\":\"Cara Membuat Penghitung Waktu Mundur di Google Sheets \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T23:04:15+00:00\",\"dateModified\":\"2023-07-20T23:04:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Google Sheets, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat penghitung waktu mundur di google spreadsheet\"}]},{\"@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 Google Sheets \u2013 Statorial","description":"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Google Sheets, 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-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Penghitung Waktu Mundur di Google Sheets \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Google Sheets, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T23:04:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte-a-rebours1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/","url":"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/","name":"Cara Membuat Penghitung Waktu Mundur di Google Sheets \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T23:04:15+00:00","dateModified":"2023-07-20T23:04:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat penghitung waktu mundur di Google Sheets, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/hitung-mundur-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat penghitung waktu mundur di google spreadsheet"}]},{"@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\/2735"}],"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=2735"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2735\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}