{"id":1765,"date":"2023-11-06T10:44:49","date_gmt":"2023-11-06T10:44:49","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/"},"modified":"2023-12-06T06:17:54","modified_gmt":"2023-12-06T06:17:54","slug":"waktu-rata-rata-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/","title":{"rendered":"Bagaimana cara menghitung rata-rata nilai waktu?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2360645675\"><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>Dalam tutorial ini, kita akan mempelajari cara menghitung rata-rata nilai waktu yang Anda miliki dalam suatu rentang sel.<\/p><h2 class=\"wp-block-heading\"> Rumus waktu rata-rata<\/h2><p> Dalam contoh berikut, Anda memiliki tiga nilai waktu di kolom A dalam rentang A1:A3. Anda sekarang perlu menghitung rata-rata nilai waktu ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79293\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-moyenne-des-valeurs-de-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung nilai rata-rata waktu\" width=\"442\" height=\"364\"><\/figure><\/div><p> Untuk melakukan ini, Anda harus menggunakan fungsi AVERAGE.<\/p><ol type=\"1\"><li> Masukkan fungsi rata-rata dalam sel menggunakan tanda sama dengan.<\/li><li> Kemudian masukkan fungsi AVERAGE dan mulai tanda kurung.<\/li><li> Lihat rentang di mana Anda punya waktu.<\/li><li> Terakhir, masukkan tanda kurung penutup dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79294\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-moyenne-pour-trouver-la-moyenne-de-la-valeur-du-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"rata-rata-untuk-menemukan-nilai-waktu-rata-rata\" width=\"560\" height=\"358\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AVERAGE(A1:A3)<\/code><\/pre><p> Di sel tempat Anda ingin menghitung rata-rata waktu, Anda perlu memastikan Anda memiliki format waktu di sel tersebut. Bahkan jika Anda tidak mengubah formatnya, Excel cukup pintar untuk mengubah format itu untuk Anda saat Anda memasukkan rumus ke dalamnya.<\/p><h2 class=\"wp-block-heading\"> Memahami waktu di Excel<\/h2><p> Di Excel, <strong><mark class=\"has-inline-color\" style=\"background-color: #eedc82;\">saat Anda memasukkan waktu dalam sel, Excel secara otomatis memberikan formatnya<\/mark><\/strong> . Ada dua cara untuk memformat nilai waktu, satu dalam format 12 jam dan yang lainnya dalam format 24 jam. Saat Anda menghitung rata-rata waktu dan memiliki format 12 jam, Anda harus sedikit berhati-hati. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79295\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-comprendre-le-temps-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"memahami-waktu-di-excel\" width=\"325\" height=\"154\"><\/figure><\/div><p> Di atas kita mempunyai dua waktu yang berbeda, yang pertama adalah pukul 06.30 dan yang kedua adalah pukul 18.30. Inilah sebabnya mengapa rata-ratanya berbeda dengan kedua rumus tersebut.<\/p><h2 class=\"wp-block-heading\"> Mengapa saya mendapatkan #DIV\/0! Kesalahan saat menghitung rata-rata waktu<\/h2><p> Jika nilai waktu Anda disimpan sebagai teks di dalam sel, Anda mungkin menemukan <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-pembagian\/\">#DIV\/0! kesalahan<\/a> . Di bawah ini kami memiliki daftar nilai waktu yang disimpan sebagai teks dan ketika dirata-ratakan kami mendapatkan kesalahan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79297\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Erreur-de-4-div-lors-de-la-moyenne-du-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"#div-kesalahan-sementara-waktu rata-rata\" width=\"346\" height=\"185\"><\/figure><\/div><p> Untuk mengatasi masalah ini, Anda dapat menggunakan rumus berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79298\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-formule-pour-ignorer-lerreur-div.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-untuk-mengabaikan-#div-error\" width=\"575\" height=\"368\"><\/figure><\/div><p> Anda perlu memasukkan rumus ini sebagai rumus array menggunakan <strong><mark class=\"has-inline-color\" style=\"background-color: #eedc82;\">Ctrl + Shift + Enter<\/mark><\/strong> . <\/p><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\/11\/temps-moyen.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/nilai-maksimum-rata-rata\/\">Rata-rata dari 5 nilai tertinggi di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rata-rata-tertimbang\/\">Hitung rata-rata tertimbang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rata-rata-kesalahan-yang-diabaikan-2\/\">Rata-rata tetapi mengabaikan kesalahan (#N\/A dan kesalahan lainnya)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rata-rata-tidak-termasuk-angka-nol-2\/\">Angka rata-rata tetapi tidak termasuk angka nol<\/a><\/li><\/ul><\/div><\/div><\/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-1765","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 menghitung rata-rata nilai waktu?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk nilai waktu rata-rata dari rentang sel. 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\/waktu-rata-rata-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghitung rata-rata nilai waktu?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk nilai waktu rata-rata dari rentang sel. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-moyenne-des-valeurs-de-temps.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-rata-rata-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/\",\"name\":\"Bagaimana cara menghitung rata-rata nilai waktu?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-moyenne-des-valeurs-de-temps.png\",\"datePublished\":\"2023-11-06T10:44:49+00:00\",\"dateModified\":\"2023-12-06T06:17:54+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk nilai waktu rata-rata dari rentang sel. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-moyenne-des-valeurs-de-temps.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-moyenne-des-valeurs-de-temps.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung rata-rata nilai waktu?\"}]},{\"@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 menghitung rata-rata nilai waktu?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk nilai waktu rata-rata dari rentang sel. 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\/waktu-rata-rata-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghitung rata-rata nilai waktu?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk nilai waktu rata-rata dari rentang sel. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-moyenne-des-valeurs-de-temps.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-rata-rata-2\/","url":"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/","name":"Bagaimana cara menghitung rata-rata nilai waktu?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-moyenne-des-valeurs-de-temps.png","datePublished":"2023-11-06T10:44:49+00:00","dateModified":"2023-12-06T06:17:54+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk nilai waktu rata-rata dari rentang sel. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-moyenne-des-valeurs-de-temps.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-calculer-la-moyenne-des-valeurs-de-temps.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/waktu-rata-rata-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung rata-rata nilai waktu?"}]},{"@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\/1765","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=1765"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1765\/revisions"}],"predecessor-version":[{"id":2658,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1765\/revisions\/2658"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}