{"id":3623,"date":"2023-07-16T11:55:45","date_gmt":"2023-07-16T11:55:45","guid":{"rendered":"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/"},"modified":"2023-07-16T11:55:45","modified_gmt":"2023-07-16T11:55:45","slug":"durasi-waktu-jumlah-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/","title":{"rendered":"Cara menambahkan durasi di google sheets (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut untuk menjumlahkan rentang durasi di Google Spreadsheet:<\/span><\/p>\n

 =<\/span> ARRAYFORMULA<\/span> (<\/span> TEXT<\/span> (<\/span> SUM<\/span> (<\/span> IFERROR<\/span> (<\/span> TIMEVALUE<\/span> (<\/span> C2:C8<\/span> )<\/span> )<\/span> )<\/span> ,<\/span> \" [h]:mm:ss<\/span> \"<\/span> )<\/span> )<\/span>\n<\/strong><\/span><\/pre>\n
 Rumus khusus ini menjumlahkan semua durasi dalam rentang C2:C8<\/strong> dan menampilkan hasilnya dalam format jam, menit, dan detik.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Tambahkan durasi di Google Spreadsheet<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang menunjukkan durasi berbagai peristiwa:<\/span><\/span> <\/p>\n
\"\"<\/p>\n
 Misalkan kita mencoba menggunakan fungsi SUM()<\/strong> untuk menambahkan durasi di kolom C:<\/span><\/p>\n
 =<\/span> SUM( C2:C8<\/span> )<\/span><\/strong><\/span><\/pre>\n
 Ternyata rumus ini akan secara efektif mengatur ulang jumlah ke 0 setiap kali jumlah durasinya melebihi 24 jam:<\/span> <\/p>\n
\"\"<\/p>\n
 Sebagai gantinya, kita perlu menggunakan rumus berikut untuk menghitung jumlah durasinya:<\/span><\/p>\n
 =<\/span> ARRAYFORMULA<\/span> (<\/span> TEXT<\/span> (<\/span> SUM<\/span> (<\/span> IFERROR<\/span> (<\/span> TIMEVALUE<\/span> (<\/span> C2:C8<\/span> )<\/span> )<\/span> )<\/span> ,<\/span> \" [h]:mm:ss<\/span> \"<\/span> )<\/span> )<\/span><\/strong><\/span><\/pre>\n
 Rumus ini menghitung jumlah durasi dengan benar:<\/span> <\/p>\n
\"\"<\/p>\n
 Jumlah nilai pada kolom durasi ternyata 44 jam, 53 menit, dan 6 detik.<\/span><\/p>\n
 Sumber daya tambahan<\/span><\/strong><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara mengonversi stempel waktu ke tanggal di Google Spreadsheet<\/a>
 Cara mengurutkan berdasarkan tanggal di Google Sheets<\/a>
 Cara Membandingkan Tanggal di Google Spreadsheet<\/a>
 Bagaimana cara menambahkan bulan hingga saat ini di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut untuk menjumlahkan rentang durasi di Google Spreadsheet: = ARRAYFORMULA ( TEXT ( SUM ( IFERROR ( TIMEVALUE ( C2:C8 ) ) ) , ” [h]:mm:ss ” ) ) Rumus khusus ini menjumlahkan semua durasi dalam rentang C2:C8 dan menampilkan hasilnya dalam format jam, menit, dan detik. Contoh berikut menunjukkan cara […]<\/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":"\nCara Menambahkan Durasi di Google Sheets (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan durasi di Google Sheets, dengan sebuah 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\/durasi-waktu-jumlah-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menambahkan Durasi di Google Sheets (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan durasi di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T11:55:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heure-dete1.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\/durasi-waktu-jumlah-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/\",\"name\":\"Cara Menambahkan Durasi di Google Sheets (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T11:55:45+00:00\",\"dateModified\":\"2023-07-16T11:55:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan durasi di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambahkan durasi di google sheets (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 Menambahkan Durasi di Google Sheets (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menambahkan durasi di Google Sheets, dengan sebuah 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\/durasi-waktu-jumlah-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menambahkan Durasi di Google Sheets (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menambahkan durasi di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-16T11:55:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/heure-dete1.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\/durasi-waktu-jumlah-google-sheet\/","url":"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/","name":"Cara Menambahkan Durasi di Google Sheets (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T11:55:45+00:00","dateModified":"2023-07-16T11:55:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan durasi di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/durasi-waktu-jumlah-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambahkan durasi di google sheets (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\/3623"}],"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=3623"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3623\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}