{"id":3923,"date":"2023-07-14T17:50:48","date_gmt":"2023-07-14T17:50:48","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/"},"modified":"2023-07-14T17:50:48","modified_gmt":"2023-07-14T17:50:48","slug":"google-sheet-mengubah-menit-menjadi-jam","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/","title":{"rendered":"Google spreadsheet: cara mengonversi menit ke jam"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mengubah menit menjadi jam di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, ini mudah dilakukan dan tutorial ini menjelaskan cara melakukan konversi berikut di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Ubah menit menjadi jam<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> Ubah menit menjadi jam dan menit<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan setiap konversi ini dalam praktiknya dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31546 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heures11.jpg\" alt=\"\" width=\"480\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Ubah menit menjadi jam di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk mengonversi jam menjadi menit di Google Spreadsheet, cukup bagi menit dengan 60.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/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 style=\"color: #ff6600;\">B2<\/span> \/ <span style=\"color: #3366ff;\">60<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-31547\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heures2.jpg\" alt=\"Google Spreadsheet mengubah menit menjadi jam\" width=\"516\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C sekarang menampilkan menit di kolom B dalam satuan jam.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">30 menit sama dengan <strong>0,5<\/strong> jam.<\/span><\/li>\n<li> <span style=\"color: #000000;\">35 menit sama dengan <strong>0,5833<\/strong> jam.<\/span><\/li>\n<li> <span style=\"color: #000000;\">71 menit sama dengan <strong>1,1833<\/strong> jam.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Ubah menit menjadi jam dan menit di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk mengonversi jam menjadi jam dan menit di Google Spreadsheet, kita perlu mengikuti dua langkah.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Bagilah menit dengan 1.440<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita perlu membagi menit dengan 1440.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/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 style=\"color: #ff6600;\">B2<\/span> \/ <span style=\"color: #3366ff;\">1440<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31548 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heures3.jpg\" alt=\"\" width=\"497\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Format Sel<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, kita perlu memformat sel sehingga nilainya ditampilkan dalam jam dan menit.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot sel dalam rentang <strong>C2:C11<\/strong> , lalu klik tab <strong>Format<\/strong> , lalu <strong>Number<\/strong> , lalu <strong>Custom Number Format<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31549 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heures4.jpg\" alt=\"\" width=\"527\" height=\"599\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, ketik <strong>[h]:mm<\/strong> lalu klik <strong>Apply<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31550 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heures5.jpg\" alt=\"\" width=\"509\" height=\"573\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sel akan secara otomatis diformat dalam jam dan menit:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31551 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heures6.jpg\" alt=\"\" width=\"509\" height=\"510\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">30 menit sama dengan <strong>0 jam 30 menit<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">35 menit sama dengan <strong>0 jam 35 menit<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">71 menit sama dengan <strong>1 jam 11 menit<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/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 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>Seringkali Anda mungkin ingin mengubah menit menjadi jam di Google Spreadsheet. Untungnya, ini mudah dilakukan dan tutorial ini menjelaskan cara melakukan konversi berikut di Google Spreadsheet: 1. Ubah menit menjadi jam 2. Ubah menit menjadi jam dan menit Contoh berikut menunjukkan cara melakukan setiap konversi ini dalam praktiknya dengan kumpulan data berikut di Google Spreadsheet: [&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>Google Spreadsheet: Cara mengonversi menit ke jam \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah menit menjadi jam di Google Sheets, 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-mengubah-menit-menjadi-jam\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara mengonversi menit ke jam \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah menit menjadi jam di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T17:50:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heures11.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-mengubah-menit-menjadi-jam\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/\",\"name\":\"Google Spreadsheet: Cara mengonversi menit ke jam \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T17:50:48+00:00\",\"dateModified\":\"2023-07-14T17:50:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah menit menjadi jam di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara mengonversi menit ke jam\"}]},{\"@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":"Google Spreadsheet: Cara mengonversi menit ke jam \u2013 Statorial","description":"Tutorial ini menjelaskan cara mengubah menit menjadi jam di Google Sheets, 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-mengubah-menit-menjadi-jam\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengonversi menit ke jam \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mengubah menit menjadi jam di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/","og_site_name":"Statorials","article_published_time":"2023-07-14T17:50:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heures11.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-mengubah-menit-menjadi-jam\/","url":"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/","name":"Google Spreadsheet: Cara mengonversi menit ke jam \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T17:50:48+00:00","dateModified":"2023-07-14T17:50:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah menit menjadi jam di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-mengubah-menit-menjadi-jam\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara mengonversi menit ke jam"}]},{"@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\/3923"}],"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=3923"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3923\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}