{"id":1807,"date":"2023-11-03T07:55:04","date_gmt":"2023-11-03T07:55:04","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/"},"modified":"2023-12-06T06:15:16","modified_gmt":"2023-12-06T06:15:16","slug":"tambahkan-detik-ke-waktu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/","title":{"rendered":"Bagaimana cara menambahkan detik ke waktu di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-411639584\"><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>Untuk menambahkan detik ke nilai waktu di Excel, Anda bisa menggunakan rumus sederhana dan singkat di mana Anda perlu merujuk ke waktu asli sel dan detik yang ingin Anda tambahkan setelah dibagi dengan 86400 (yaitu total detik yang kita miliki dalam sehari).<\/p><p> Di bawah ini kita memiliki nilai waktu di sel A1 (11:30:18). Dan Anda perlu menambahkan 34 detik ke waktu ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79215\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-dans-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai waktu dalam sel\" width=\"439\" height=\"278\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Rumus Excel untuk menambahkan detik ke nilai waktu<\/h2><p> Anda dapat menggunakan langkah-langkah di bawah ini:<\/p><ol type=\"1\"><li> Pertama, masukkan operator sama dengan di sel dan rujuk ke sel tempat Anda punya waktu.<\/li><li> Setelah itu masukkan operator penjumlahan lalu masukkan tanda kurung pertama.<\/li><li> Sekarang masukkan nilai detik yang ingin Anda tambahkan ke waktu.<\/li><li> Selanjutnya masukkan operator pembagian dan masukkan 86400.<\/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-79216\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-ajouter-des-secondes-a-la-valeur-du-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"tambahkan detik ke nilai waktu\" width=\"591\" height=\"254\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1+(34\/86400)<\/code><\/pre><h2 class=\"wp-block-heading\"> Gunakan fungsi TIME untuk menambahkan detik<\/h2><p> Demikian pula, Anda juga bisa menggunakan fungsi TIME Excel untuk menambahkan detik ke satu jam. Lihat contoh di bawah ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79217\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-3-temps-pour-ajouter-des-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi waktu untuk menambahkan detik\" width=\"583\" height=\"249\"><\/figure><\/div><ol type=\"1\"><li> Dalam rumus ini Anda perlu merujuk ke sel tempat Anda punya waktu.<\/li><li> Setelah itu gunakan operator penjumlahan dan masuk ke fungsi TIME.<\/li><li> Dalam fungsi waktu, ada tiga argumen yang harus didefinisikan: jam, menit, dan detik. Gunakan nol untuk jam dan menit; masukkan detik yang ingin Anda tambahkan ke waktu asli.<\/li><li> Pada akhirnya, tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1+TIME(0,0,34)<\/code><\/pre><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\/ajouter-des-secondes.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-1807","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>\u25b7 Bagaimana cara menambahkan detik ke waktu di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan detik ke nilai waktu. 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\/tambahkan-detik-ke-waktu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menambahkan detik ke waktu di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan detik ke nilai waktu. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-dans-la-cellule.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/\",\"name\":\"\u25b7 Bagaimana cara menambahkan detik ke waktu di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-dans-la-cellule.png\",\"datePublished\":\"2023-11-03T07:55:04+00:00\",\"dateModified\":\"2023-12-06T06:15:16+00:00\",\"description\":\"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan detik ke nilai waktu. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-dans-la-cellule.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-dans-la-cellule.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan detik ke 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":"\u25b7 Bagaimana cara menambahkan detik ke waktu di Excel?","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan detik ke nilai waktu. 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\/tambahkan-detik-ke-waktu\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambahkan detik ke waktu di Excel?","og_description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan detik ke nilai waktu. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-dans-la-cellule.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/","url":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/","name":"\u25b7 Bagaimana cara menambahkan detik ke waktu di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-dans-la-cellule.png","datePublished":"2023-11-03T07:55:04+00:00","dateModified":"2023-12-06T06:15:16+00:00","description":"Tutorial ini akan mengajarkan Anda cara menulis rumus Excel untuk menambahkan detik ke nilai waktu. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-dans-la-cellule.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-temps-dans-la-cellule.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-detik-ke-waktu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan detik ke 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\/1807","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=1807"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1807\/revisions"}],"predecessor-version":[{"id":2401,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1807\/revisions\/2401"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}