{"id":2669,"date":"2023-07-21T06:19:22","date_gmt":"2023-07-21T06:19:22","guid":{"rendered":"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/"},"modified":"2023-07-21T06:19:22","modified_gmt":"2023-07-21T06:19:22","slug":"lembar-perbedaan-waktu-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/","title":{"rendered":"Cara menghitung perbedaan waktu di google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menghitung perbedaan waktu antara dua jam di Google Spreadsheet:<\/span><\/p>\n

 = B1<\/span> - A1\n<\/span><\/strong><\/pre>\n
 Rumus khusus ini mengasumsikan waktu mulai di sel A1<\/strong> dan waktu berakhir di sel B1<\/strong> .<\/span><\/p>\n
 Agar rumus ini berfungsi dengan benar, sel di A1 dan B1 harus memiliki format Tanggal\/Waktu<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Hitung perbedaan waktu di Google Spreadsheet<\/strong><\/span><\/h3>\n
 Katakanlah kita memiliki dua kolom berikut di Google Spreadsheet yang menampilkan waktu mulai dan berakhirnya acara tertentu:<\/span><\/p>\n
 \"\"<\/span><\/p>\n
 Sebelum menghitung selisih waktu setiap event, kita perlu memastikan waktunya dalam format Tanggal Waktu.<\/span><\/span><\/p>\n
 Untuk melakukannya, sorot sel dalam rentang A2:B5<\/strong> , lalu klik tab Format<\/strong> di sepanjang pita atas, lalu klik Nomor<\/strong> , lalu klik Tanggal Waktu<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Setiap waktu akan otomatis dikonversi ke format Tanggal\/Waktu:<\/span> <\/p>\n
\"\"<\/p>\n
 Lalu kita cukup mengurangi waktu mulai dari waktu berakhir:<\/span> <\/p>\n
\"\"<\/p>\n
 Untuk mengonversi perbedaan waktu ke format waktu, sorot sel dalam rentang C2:C5<\/strong> , lalu klik tab Format<\/strong> di sepanjang pita atas, lalu klik Nomor<\/strong> , lalu klik Durasi<\/strong> .<\/span><\/p>\n
 Offset waktu akan secara otomatis dikonversi ke format Jam:Menit:Detik.<\/span> <\/p>\n
\"Perbedaan<\/p>\n
 Jika Anda ingin mengekstrak jam, menit, dan detik satu per satu dari perbedaan waktu, Anda dapat menggunakan fungsi HOUR<\/strong> , MINUTE<\/strong> , dan SECOND<\/strong> :<\/span><\/span> <\/p>\n
\"\"<\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara memfilter berdasarkan rentang tanggal di Google Spreadsheet<\/a>
 Cara menggunakan fungsi TODAY() dalam kueri Google Sheets<\/a>
 Cara menghitung selisih dua tanggal di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menghitung perbedaan waktu antara dua jam di Google Spreadsheet: = B1 – A1 Rumus khusus ini mengasumsikan waktu mulai di sel A1 dan waktu berakhir di sel B1 . Agar rumus ini berfungsi dengan benar, sel di A1 dan B1 harus memiliki format Tanggal\/Waktu . Contoh berikut menunjukkan […]<\/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 menghitung perbedaan waktu di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung perbedaan waktu di Google Sheets, dengan contoh lengkap.\" \/>\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\/lembar-perbedaan-waktu-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung perbedaan waktu di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung perbedaan waktu di Google Sheets, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T06:19:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/timediff1.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\/lembar-perbedaan-waktu-google\/\",\"url\":\"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/\",\"name\":\"Cara menghitung perbedaan waktu di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T06:19:22+00:00\",\"dateModified\":\"2023-07-21T06:19:22+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung perbedaan waktu di Google Sheets, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung perbedaan waktu di google sheets\"}]},{\"@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 perbedaan waktu di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung perbedaan waktu di Google Sheets, dengan contoh lengkap.","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\/lembar-perbedaan-waktu-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung perbedaan waktu di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung perbedaan waktu di Google Sheets, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/","og_site_name":"Statorials","article_published_time":"2023-07-21T06:19:22+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/timediff1.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\/lembar-perbedaan-waktu-google\/","url":"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/","name":"Cara menghitung perbedaan waktu di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T06:19:22+00:00","dateModified":"2023-07-21T06:19:22+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung perbedaan waktu di Google Sheets, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lembar-perbedaan-waktu-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung perbedaan waktu di google sheets"}]},{"@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\/2669"}],"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=2669"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2669\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}