{"id":3942,"date":"2023-07-14T14:51:41","date_gmt":"2023-07-14T14:51:41","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/"},"modified":"2023-07-14T14:51:41","modified_gmt":"2023-07-14T14:51:41","slug":"excel-mengkonversi-menit-jam-dan-menit","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/","title":{"rendered":"Excel: cara mengubah menit menjadi jam dan menit"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mengubah menit menjadi jam dan menit di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan kumpulan data berikut ke dalam Excel yang menunjukkan waktu (dalam menit) yang dibutuhkan atlet berbeda untuk menyelesaikan suatu tugas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31688 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minutes1.jpg\" alt=\"\" width=\"493\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Bagi menitnya dengan 1.440<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menampilkan menit sebagai jam dan menit, bagilah terlebih dahulu setiap nilai pada kolom menit dengan 1440.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita ketik rumus berikut di sel <strong>C2<\/strong> , lalu seret dan isi rumus di setiap<\/span> <span style=\"color: #000000;\">sel tersisa di kolom C:<\/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: #3366ff;\">B2<\/span> \/1440<\/span><\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31689 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minutes2.jpg\" alt=\"\" width=\"543\" height=\"456\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Format Sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu memformat sel sehingga nilainya ditampilkan dalam jam dan menit.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot sel dalam rentang <strong>C2:C11<\/strong> , lalu klik menu tarik-turun <strong>Format Angka<\/strong> , lalu klik <strong>Format Angka Lainnya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31690 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minutes3.jpg\" alt=\"\" width=\"649\" height=\"590\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Custom<\/strong> di daftar <strong>Kategori<\/strong> , lalu ketik <strong>[h]:mm<\/strong> di jendela <strong>Type<\/strong> , lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31691 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minutes4.jpg\" alt=\"\" width=\"558\" height=\"560\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , sel secara otomatis akan diformat dalam jam dan menit:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31692 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minutes5.jpg\" alt=\"\" width=\"501\" height=\"460\" 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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-mengubah-waktu-menjadi-menit\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengubah durasi menjadi menit<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/perbedaan-excel-antara-waktu-dalam-hitungan-menit\/\" target=\"_blank\" rel=\"noopener\">Excel: hitung selisih dua kali dalam hitungan menit<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/perbedaan-excel-antara-waktu-dalam-jam\/\" target=\"_blank\" rel=\"noopener\">Excel: hitung selisih dua kali dalam jam<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin mengubah menit menjadi jam dan menit di Excel. Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya. Langkah 1: Masukkan datanya Pertama, masukkan kumpulan data berikut ke dalam Excel yang menunjukkan waktu (dalam menit) yang dibutuhkan atlet berbeda untuk menyelesaikan suatu tugas: Langkah 2: Bagi menitnya [&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: Bagaimana mengkonversi menit ke jam dan menit - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah menit menjadi jam dan menit di Excel, dengan contoh langkah demi langkah.\" \/>\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\/excel-mengkonversi-menit-jam-dan-menit\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Bagaimana mengkonversi menit ke jam dan menit - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah menit menjadi jam dan menit di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T14:51:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minutes1.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\/excel-mengkonversi-menit-jam-dan-menit\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/\",\"name\":\"Excel: Bagaimana mengkonversi menit ke jam dan menit - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T14:51:41+00:00\",\"dateModified\":\"2023-07-14T14:51:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah menit menjadi jam dan menit di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengubah menit menjadi jam dan menit\"}]},{\"@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: Bagaimana mengkonversi menit ke jam dan menit - Statorials","description":"Tutorial ini menjelaskan cara mengubah menit menjadi jam dan menit di Excel, dengan contoh langkah demi langkah.","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\/excel-mengkonversi-menit-jam-dan-menit\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Bagaimana mengkonversi menit ke jam dan menit - Statorials","og_description":"Tutorial ini menjelaskan cara mengubah menit menjadi jam dan menit di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/","og_site_name":"Statorials","article_published_time":"2023-07-14T14:51:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minutes1.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\/excel-mengkonversi-menit-jam-dan-menit\/","url":"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/","name":"Excel: Bagaimana mengkonversi menit ke jam dan menit - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T14:51:41+00:00","dateModified":"2023-07-14T14:51:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah menit menjadi jam dan menit di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-mengkonversi-menit-jam-dan-menit\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengubah menit menjadi jam dan menit"}]},{"@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\/3942"}],"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=3942"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3942\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}