{"id":1727,"date":"2023-11-09T17:04:53","date_gmt":"2023-11-09T17:04:53","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/"},"modified":"2023-12-06T06:15:55","modified_gmt":"2023-12-06T06:15:55","slug":"waktu-tidur-siang-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/","title":{"rendered":"Bagaimana cara menambahkan waktu di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1216385994\"><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>Di Excel, jika Anda ingin menjumlahkan nilai waktu, Anda perlu menggunakan fungsi penjumlahan untuk menjumlahkan nilainya, lalu Anda perlu mengubah format untuk memperlihatkan jumlah total jam dan menit. Di bawah ini adalah daftar nilai waktu yang kita tambahkan bersama di sel C2. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79498\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah-jam-di-excel\" width=\"573\" height=\"347\"><\/figure><\/div><p> Dalam tutorial ini, kita mempelajari cara menulis rumus ini dan menerapkan pemformatan yang benar.<\/p><h2 class=\"wp-block-heading\"> Tulis Rumus untuk Menambah Waktu di Excel<\/h2><ol type=\"1\"><li> Pertama, di sel C2, masukkan fungsi penjumlahan.<\/li><li> Sekarang masukkan tanda kurung awal.<\/li><li> Setelah itu, rujuk ke rentang sel dimana kamu mempunyai nilai waktu.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter untuk mendapatkan hasilnya.<\/li><\/ol><p> Ini akan memberi Anda sejumlah nilai, tetapi format ini tidak benar dan kita perlu mengubah format ini menggunakan pemformatan khusus. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79499\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formule-pour-additionner-le-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus untuk menjumlahkan waktu\" width=\"571\" height=\"346\"><\/figure><\/div><ol type=\"1\"><li> Saat memilih sel, buka opsi format dengan pintasan keyboard (Ctrl+1).<\/li><li> Sekarang klik opsi Kustom.<\/li><li> Setelah itu, klik pada bilah input format.<\/li><li> Selanjutnya, masukkan [h]:mm di bilah input.<\/li><li> Pada akhirnya, klik OK untuk menerapkan pemformatan. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79500\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-changer-le-format-de-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"ubah format sel\" width=\"570\" height=\"562\"><\/figure><\/div><p> Saat Anda mengklik OK, itu akan menunjukkan 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-79501\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nombre-total-dheures-et-de-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah total jam dan menit\" width=\"577\" height=\"349\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Anda harus memahami ini<\/h2><p> Excel menyimpan tanggal dan waktu sebagai angka di backend dan Anda memiliki formatnya di sel. Jadi jika Anda mengubah nilai waktu menjadi nilai, maka akan terlihat seperti berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79502\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-comprendre-les-valeurs-temporelles.png\" sizes=\"auto, \" srcset=\"\" alt=\"memahami nilai waktu\" width=\"306\" height=\"325\"><\/figure><\/div><p> <strong>Nilai waktu selalu dinyatakan dalam desimal.<\/strong><\/p><p> Sekarang ketika Anda menambahkan nilai-nilai ini, hasilnya adalah 1,4375.<\/p><p> Seperti yang saya katakan, nilai waktu selalu dalam desimal, ketika Anda menerapkan format waktu (format waktu normal HH:MM AM\/PM), Excel menunjukkan waktu berdasarkan nilai desimal yang tersisa yaitu 0,4375, dan pertimbangkan bilangan bulat yaitu 1 sebagai sehari penuh. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79503\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-valeurs-de-temps-toujours-en-decimal.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai waktu-selalu-dalam desimal\" width=\"343\" height=\"395\"><\/figure><\/div><p> Untuk mengatasi masalah ini, Anda perlu menggunakan format khusus yang telah kami gunakan dalam metode kami. Saat Anda menambahkan tanda kurung dengan formatnya, hasilnya akan menampilkan total jam. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">[h]:mm<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79504\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-format-personnalise-pour-le-nombre-total-dheures.png\" sizes=\"auto, \" srcset=\"\" alt=\"format khusus untuk total jam\" width=\"473\" height=\"299\"><\/figure><\/div><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> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/temps-de-somme.xlsx\" rel=\"nofollow\">Unduh<\/a> <\/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\/tambahkan-jam-tepat-waktu\/\">Tambahkan jam ke waktu di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-menit-ke-waktu\/\">Tambahkan menit ke waktu di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-perbedaan-waktu\/\">Hitung perbedaan waktu antara dua jam di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-format-waktu\/\">Ubah format waktu di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/waktu-militer\/\">Waktu militer (dapatkan dan kurangi) di Excel<\/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-1727","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>Bagaimana cara menambahkan waktu di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menjumlahkan nilai waktu suatu rentang sel di Excel.\" \/>\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\/waktu-tidur-siang-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menambahkan waktu di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menjumlahkan nilai waktu suatu rentang sel di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.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\/waktu-tidur-siang-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/\",\"name\":\"Bagaimana cara menambahkan waktu di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png\",\"datePublished\":\"2023-11-09T17:04:53+00:00\",\"dateModified\":\"2023-12-06T06:15:55+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menjumlahkan nilai waktu suatu rentang sel di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan waktu di excel?\"}]},{\"@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":"Bagaimana cara menambahkan waktu di Excel? (Tutorial 2023)","description":"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menjumlahkan nilai waktu suatu rentang sel di Excel.","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\/waktu-tidur-siang-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menambahkan waktu di Excel? (Tutorial 2023)","og_description":"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menjumlahkan nilai waktu suatu rentang sel di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:55+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.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\/waktu-tidur-siang-2\/","url":"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/","name":"Bagaimana cara menambahkan waktu di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png","datePublished":"2023-11-09T17:04:53+00:00","dateModified":"2023-12-06T06:15:55+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menulis rumus untuk menjumlahkan nilai waktu suatu rentang sel di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/waktu-tidur-siang-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan waktu di excel?"}]},{"@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\/1727","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=1727"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1727\/revisions"}],"predecessor-version":[{"id":2470,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1727\/revisions\/2470"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}