{"id":3502,"date":"2023-07-17T03:50:28","date_gmt":"2023-07-17T03:50:28","guid":{"rendered":"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/"},"modified":"2023-07-17T03:50:28","modified_gmt":"2023-07-17T03:50:28","slug":"waktu-rata-rata-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/","title":{"rendered":"Cara menghitung waktu rata-rata di excel: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menghitung nilai waktu rata-rata di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=AVERAGE( <span style=\"color: #3366ff;\">A2:A11<\/span> )\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung nilai waktu rata-rata dalam rentang <strong>A2:A11<\/strong> dan mengasumsikan bahwa setiap nilai dalam rentang tersebut berada dalam format waktu yang valid.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: menghitung waktu rata-rata di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar waktu berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29145 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/duree-moyenne1.jpg\" alt=\"\" width=\"458\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk memverifikasi bahwa waktu berada dalam format yang valid, kita dapat menyorot rentang <strong>A2:A11<\/strong> lalu klik menu tarik-turun <strong>Format Angka<\/strong> di tab <strong>Angka<\/strong> pada tab <strong>Beranda<\/strong> di pita atas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29146 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/duree-moyenne2.jpg\" alt=\"\" width=\"675\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita mengklik <strong>More Number Formats<\/strong> , layar baru akan muncul menunjukkan format yang dipilih Excel untuk nilainya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29147 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/duree-moyenne3.jpg\" alt=\"\" width=\"610\" height=\"527\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, Excel memilih <strong>h:mm:ss AM\/PM<\/strong> , yang merupakan format waktu yang tepat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai waktu Anda dalam format lain, cukup klik format yang sesuai dari daftar opsi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian dapat mengklik <strong>OK<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian <span style=\"color: #000000;\">kita dapat menggunakan rumus berikut untuk menghitung nilai waktu rata-rata:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=AVERAGE( <span style=\"color: #3366ff;\">A2:A11<\/span> )<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-29148\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/temps-moyen4.jpg\" alt=\"menghitung waktu rata-rata di Excel\" width=\"466\" height=\"492\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat melihat bahwa waktu rata-rata adalah <strong>12:11:51 PM<\/strong> .<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Waktu Rata-Rata dengan Suatu Kondisi di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita juga bisa menggunakan fungsi <strong>AVERAGEIF<\/strong> untuk menghitung waktu rata-rata berdasarkan suatu kondisi di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menggunakan rumus berikut untuk menghitung waktu rata-rata hanya untuk jam-jam yang terjadi setelah jam 12 siang:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=AVERAGEIF( <span style=\"color: #3366ff;\">A2:A11<\/span> , \"&gt;12:00:00 PM\")\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29150 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/duree-moyenne5.jpg\" alt=\"\" width=\"552\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Excel mengembalikan nilai numerik, tapi kita bisa mengklik lagi menu drop-down <strong>Format Angka<\/strong> dan klik <strong>Waktu<\/strong> untuk mengonversi nilai numerik ini menjadi nilai waktu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29151 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/duree-moyenne6.jpg\" alt=\"\" width=\"528\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Waktu rata-rata di antara waktu-waktu yang terjadi setelah pukul 12 siang adalah <strong>17:18:19<\/strong> .<\/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\/rata-rata-excel-jika-sel-berisi-angka\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata jika sel berisi angka di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-dalam-beberapa-rentang\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan AVERAGEIF dengan beberapa rentang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-tidak-termasuk-outlier\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung mean tidak termasuk outlier di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menghitung nilai waktu rata-rata di Excel: =AVERAGE( A2:A11 ) Rumus khusus ini menghitung nilai waktu rata-rata dalam rentang A2:A11 dan mengasumsikan bahwa setiap nilai dalam rentang tersebut berada dalam format waktu yang valid. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: menghitung waktu rata-rata di Excel Misalkan [&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>Cara Menghitung Waktu Rata-Rata di Excel (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai waktu rata-rata di Excel, dengan beberapa contoh.\" \/>\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\/waktu-rata-rata-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Waktu Rata-Rata di Excel (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai waktu rata-rata di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T03:50:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/duree-moyenne1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/\",\"name\":\"Cara Menghitung Waktu Rata-Rata di Excel (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T03:50:28+00:00\",\"dateModified\":\"2023-07-17T03:50:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai waktu rata-rata di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung waktu rata-rata di excel: dengan contoh\"}]},{\"@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":"Cara Menghitung Waktu Rata-Rata di Excel (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menghitung nilai waktu rata-rata di Excel, dengan beberapa contoh.","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\/waktu-rata-rata-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Waktu Rata-Rata di Excel (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menghitung nilai waktu rata-rata di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-17T03:50:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/duree-moyenne1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/","url":"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/","name":"Cara Menghitung Waktu Rata-Rata di Excel (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T03:50:28+00:00","dateModified":"2023-07-17T03:50:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai waktu rata-rata di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/waktu-rata-rata-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung waktu rata-rata di excel: dengan contoh"}]},{"@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\/3502"}],"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=3502"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3502\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}