{"id":1711,"date":"2023-11-10T09:45:03","date_gmt":"2023-11-10T09:45:03","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/"},"modified":"2023-12-06T06:18:07","modified_gmt":"2023-12-06T06:18:07","slug":"detik-hingga-jam-menit","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/","title":{"rendered":"Bagaimana cara mengubah detik menjadi jam dan menit?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3059722475\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk mengonversi detik menjadi jam atau menit di Excel, Anda perlu membagi nilai detik yang Anda miliki dengan jumlah total detik yang Anda miliki dalam satu hari. Setelah itu, Anda perlu mengubah format menjadi jam dan menit. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80514\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengkonversi detik ke jam dan menit\" width=\"583\" height=\"268\"><\/figure><\/div><p> Dalam tutorial ini, Anda akan mempelajari cara menulis dan memahami rumus-rumus ini secara detail. Sebagai referensi Anda, pada contoh di bawah ini Anda memiliki 10.000 detik di sel A1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80515\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-secondes-comme-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"kedua sebagai nilai\" width=\"433\" height=\"194\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Konversi detik ke jam (jj:mm:ss)<\/h2><p> Berikut langkah-langkah menulis rumus tersebut:<\/p><ol><li> Pertama, di dalam sel, masukkan rumus untuk membagi detik dengan 86400 (jumlah total detik dalam sehari). <br><img loading=\"lazy\" decoding=\"async\" title=\"3-bagi-detik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-diviser-les-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"divide-the-seconds\" width=\"515\" height=\"262\"><\/li><li> Setelah itu, buka <a href=\"https:\/\/exceladvisor.org\/id\/buka-opsi-format-sel\/\">Opsi Format (Ctrl+1)<\/a> . <br><img loading=\"lazy\" decoding=\"async\" title=\"Format terbuka 4 sel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cellules-au-format-ouvert.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-format-cells\" width=\"513\" height=\"358\"><\/li><li> Sekarang, di daftar kategori, klik \u201cKustom\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-pilih-kategori khusus\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-selectionnez-la-categorie-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-custom-category\" width=\"596\" height=\"323\"><\/li><li> Kemudian, di bilah input ketik, masukkan [hh]:mm atau [hh]:mm:ss. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-Masukkan Nilai Khusus\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-entrez-la-valeur-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-custom-value\" width=\"593\" height=\"290\"><\/li><li> Pada akhirnya, klik OK untuk menerapkan pemformatan.<\/li><\/ol><p> Saat Anda menekan OK, ini memberi Anda jumlah total jam dan menit. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80520\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-nombre-total-dheures-et-de-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah total jam dan menit\" width=\"475\" height=\"238\"><\/figure><\/div><p class=\"grey-note\"> <strong>Daripada menggunakan jj:mm:ss, di sini kita menggunakan [hh]:mm atau [hh]:mm:ss.<\/strong><\/p><p class=\"grey-note\"> Karena ketika Anda menggunakan jj:mm dan Anda memiliki detik lebih besar dari jumlah detik dalam sehari, Anda akan mendapatkan hasil yang buruk.<\/p><p class=\"grey-note\"> Jika Anda memiliki 27 jam, ia akan memberi tahu Anda 3 jam melewati 24 jam setiap hari. Inilah sebabnya mengapa Anda harus menggunakan [hh]:mm:ss dan [hh]:mm.<\/p><h2 class=\"wp-block-heading\"> Ubah detik menjadi menit<\/h2><p> Dengan cara yang sama, Anda dapat mengonversi detik menjadi menit, Anda harus mengikuti langkah yang sama, tetapi Anda perlu menggunakan format khusus yang berbeda. Setelah Anda memasukkan rumus ke dalam sel, ubah formatnya menjadi [mm]:ss dan klik OK. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80521\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-convertir-des-secondes-en-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengkonversi detik ke menit\" width=\"782\" height=\"338\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Menggunakan Fungsi Teks untuk Mengonversi Detik ke Jam dan Menit<\/h2><p> Ya, Anda juga dapat menggunakan fungsi TEXT. Hal ini memungkinkan konversi detik menjadi hasil yang diinginkan tanpa mengubah format sel. Dalam fungsi TEXT, Anda dapat menentukan format di dalam fungsi tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80522\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-fonctions-de-texte-pour-convertir-les-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi teks-untuk-mengonversi-detik\" width=\"606\" height=\"228\"><\/figure><\/div><p> Pada argumen pertama TEXT, Anda harus memasukkan rumus detik\/total detik yang sama dalam sehari. Setelah itu pada argumen kedua (text_format), masukkan format yang ingin diberikan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1\/86400,\"[hh]:mm\") =TEXT(A1\/86400,\"[mm]:ss\")<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-les-secondes.xlsx\" rel=\"nofollow\">Unduh<\/a> <\/p><\/div><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Lebih banyak formula<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/waktu-dalam-menit-2\/\">Ubah nilai waktu menjadi menit (rumus Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/waktu-dalam-hitungan-detik-2\/\">Ubah nilai waktu menjadi detik<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/\">Dapatkan waktu saat ini (rumus Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/\">Jumlah Waktu di Excel (Rumus Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/\">Tambahkan detik ke waktu<\/a><\/li><\/ul><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1711","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara mengubah detik menjadi jam dan menit di excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah detik menjadi jam dan menit. Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengubah detik menjadi jam dan menit di excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah detik menjadi jam dan menit. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/\",\"name\":\"Cara mengubah detik menjadi jam dan menit di excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\",\"datePublished\":\"2023-11-10T09:45:03+00:00\",\"dateModified\":\"2023-12-06T06:18:07+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah detik menjadi jam dan menit. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengubah detik menjadi jam dan menit?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara mengubah detik menjadi jam dan menit di excel","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah detik menjadi jam dan menit. Mari kita periksa ini\u2026","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:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengubah detik menjadi jam dan menit di excel","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah detik menjadi jam dan menit. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/","url":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/","name":"Cara mengubah detik menjadi jam dan menit di excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png","datePublished":"2023-11-10T09:45:03+00:00","dateModified":"2023-12-06T06:18:07+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk mengubah detik menjadi jam dan menit. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/detik-hingga-jam-menit\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengubah detik menjadi jam dan menit?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1711"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1711\/revisions"}],"predecessor-version":[{"id":2684,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1711\/revisions\/2684"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}