{"id":2846,"date":"2023-07-20T10:43:33","date_gmt":"2023-07-20T10:43:33","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/"},"modified":"2023-07-20T10:43:33","modified_gmt":"2023-07-20T10:43:33","slug":"google-sheet-mengonversi-stempel-waktu-menjadi-tanggal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/","title":{"rendered":"Cara mengonversi stempel waktu ke tanggal di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk mengonversi stempel waktu menjadi tanggal dengan cepat.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Formula 1: Gunakan DATEVALUE<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">TO_DATE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">DATEVALUE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Gunakan INT<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">TO_DATE<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">INT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kedua rumus tersebut mengonversi stempel waktu di sel <strong>A1<\/strong> menjadi tanggal.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Ubah stempel waktu menjadi tanggal menggunakan DATEVALUE<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menggunakan fungsi <strong>DATEVALUE<\/strong> untuk mengonversi nilai stempel waktu di kolom A ke nilai tanggal di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24935\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horodatage1.jpg\" alt=\"Google Spreadsheet mengonversi stempel waktu menjadi tanggal\" width=\"506\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya tanggal yang ditampilkan di kolom B dan waktu telah dihapus.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Ubah stempel waktu menjadi tanggal menggunakan INT<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <b>INT<\/b> untuk mengonversi nilai stempel waktu di kolom A ke nilai tanggal di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24936 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horodatage2.jpg\" alt=\"\" width=\"508\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya tanggal yang ditampilkan di kolom B dan waktu telah dihapus.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa rumus ini mengembalikan hasil yang sama persis dengan rumus sebelumnya.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-tanggal-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara mengurutkan berdasarkan tanggal di Google Sheets<\/a><br \/> <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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk mengonversi stempel waktu menjadi tanggal dengan cepat. Formula 1: Gunakan DATEVALUE = TO_DATE ( DATEVALUE ( A1 ) ) Rumus 2: Gunakan INT = TO_DATE ( INT ( A1 ) ) Kedua rumus tersebut mengonversi stempel waktu di sel A1 menjadi tanggal. Contoh berikut menunjukkan cara [&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 mengonversi stempel waktu ke tanggal di Google Spreadsheet - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah stempel waktu menjadi tanggal di Google Spreadsheet, 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\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengonversi stempel waktu ke tanggal di Google Spreadsheet - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah stempel waktu menjadi tanggal di Google Spreadsheet, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T10:43:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horodatage1.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\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/\",\"name\":\"Cara mengonversi stempel waktu ke tanggal di Google Spreadsheet - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T10:43:33+00:00\",\"dateModified\":\"2023-07-20T10:43:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah stempel waktu menjadi tanggal di Google Spreadsheet, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengonversi stempel waktu ke tanggal 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 mengonversi stempel waktu ke tanggal di Google Spreadsheet - Statologi","description":"Tutorial ini menjelaskan cara mengubah stempel waktu menjadi tanggal di Google Spreadsheet, 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\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengonversi stempel waktu ke tanggal di Google Spreadsheet - Statologi","og_description":"Tutorial ini menjelaskan cara mengubah stempel waktu menjadi tanggal di Google Spreadsheet, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/","og_site_name":"Statorials","article_published_time":"2023-07-20T10:43:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/horodatage1.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\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/","url":"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/","name":"Cara mengonversi stempel waktu ke tanggal di Google Spreadsheet - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T10:43:33+00:00","dateModified":"2023-07-20T10:43:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah stempel waktu menjadi tanggal di Google Spreadsheet, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-mengonversi-stempel-waktu-menjadi-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengonversi stempel waktu ke tanggal 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\/2846"}],"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=2846"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2846\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}