{"id":1562,"date":"2023-11-17T05:14:11","date_gmt":"2023-11-17T05:14:11","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/"},"modified":"2023-12-06T06:15:22","modified_gmt":"2023-12-06T06:15:22","slug":"tambahkan-jam-tepat-waktu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/","title":{"rendered":"Bagaimana cara menambahkan jam dalam waktu?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3581783616\"><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 nilai waktu ke dalam nilai waktu di Excel, Anda bisa menggunakan rumus sederhana dan singkat di mana Anda perlu menentukan waktu asli dari sel dan nilai waktu yang ingin Anda tambahkan setelah membaginya dengan 24 (yang merupakan total jam yang kita miliki dalam sehari).<\/p><p> Dalam contoh berikut, kita memiliki nilai waktu di sel A1 (00:01). Dan di sini Anda perlu menambahkan 3 jam <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67588\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-de-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"sel-dengan-nilai waktu\" width=\"353\" height=\"327\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Rumus untuk menambahkan jam ke suatu waktu<\/h2><p> Langkah-langkah berikut dapat Anda gunakan untuk menambahkan waktu dalam satu jam:<\/p><ol type=\"1\"><li> Pertama, rujuk ke sel tempat Anda memiliki nilai waktu (ini adalah A1 contoh kita).<\/li><li> Setelah itu, masukkan operator penjumlahan dan ketikkan tanda kurung awal.<\/li><li> Selanjutnya, masukkan nilai waktu yang ingin Anda tambahkan ke waktu asli.<\/li><li> Sekarang masukkan operator pembagian dan ketik 24 yang merupakan jumlah total jam yang Anda miliki dalam sehari.<\/li><li> Terakhir, ketik tanda kurung tutup dan tekan Enter untuk mendapatkan nilai hasil. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67589\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-ajouter-des-heures.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus untuk menambah jam\" width=\"355\" height=\"312\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1+(3\/24)<\/code><\/pre><p> Rumusnya cukup sederhana. Anda hanya perlu menentukan nilai waktu asli (bagi dengan 24).<\/p><h2 class=\"wp-block-heading\"> Gunakan fungsi waktu untuk menambah waktu<\/h2><p> Anda juga dapat menggunakan fungsi waktu untuk menambahkan satu jam ke nilai waktu. Anda dapat melihatnya pada rumus berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67590\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-3-temps-pour-ajouter-du-temps-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"waktu-fungsi-untuk-menambah-waktu\" width=\"462\" height=\"116\"><\/figure><\/div><p> Anda perlu menentukan waktu asli, menggunakan fungsi waktu, dan hanya menentukan argumen waktu dengan waktu yang ingin Anda tambahkan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67591\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fonction-de-temps-avec-argument-heure.png\" sizes=\"auto, \" srcset=\"\" alt=\"argumen-fungsi-waktu-dengan-waktu\" width=\"398\" height=\"133\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1+TIME(3,0,0)<\/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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-des-heures-dans-le-temps-3.xlsx\" rel=\"nofollow\">Unduh<\/a> <\/p><\/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><div class=\"wp-block-columns is-layout-flex wp-container-67\"><div class=\"wp-block-column is-layout-flow\"><ul><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\/\">Perbedaan antara dua kali 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><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-dan-waktu-terpisah2\/\">Pisahkan tanggal dan waktu di Excel<\/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-1562","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 menambahkan jam dalam waktu? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini kita akan belajar bagaimana menambahkan jam ke dalam nilai waktu yang kita miliki di sel di Excel. Kami akan\" \/>\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-jam-tepat-waktu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menambahkan jam dalam waktu? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini kita akan belajar bagaimana menambahkan jam ke dalam nilai waktu yang kita miliki di sel di Excel. Kami akan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-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=\"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-jam-tepat-waktu\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/\",\"name\":\"Bagaimana cara menambahkan jam dalam waktu? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-de-temps.png\",\"datePublished\":\"2023-11-17T05:14:11+00:00\",\"dateModified\":\"2023-12-06T06:15:22+00:00\",\"description\":\"Dalam tutorial ini kita akan belajar bagaimana menambahkan jam ke dalam nilai waktu yang kita miliki di sel di Excel. Kami akan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-de-temps.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-de-temps.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan jam dalam 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 menambahkan jam dalam waktu? - Penasihat Excel","description":"Dalam tutorial ini kita akan belajar bagaimana menambahkan jam ke dalam nilai waktu yang kita miliki di sel di Excel. Kami akan","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-jam-tepat-waktu\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menambahkan jam dalam waktu? - Penasihat Excel","og_description":"Dalam tutorial ini kita akan belajar bagaimana menambahkan jam ke dalam nilai waktu yang kita miliki di sel di Excel. Kami akan","og_url":"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:22+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-de-temps.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-jam-tepat-waktu\/","url":"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/","name":"Bagaimana cara menambahkan jam dalam waktu? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-de-temps.png","datePublished":"2023-11-17T05:14:11+00:00","dateModified":"2023-12-06T06:15:22+00:00","description":"Dalam tutorial ini kita akan belajar bagaimana menambahkan jam ke dalam nilai waktu yang kita miliki di sel di Excel. Kami akan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-de-temps.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-de-temps.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan jam dalam 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\/1562","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=1562"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1562\/revisions"}],"predecessor-version":[{"id":2407,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1562\/revisions\/2407"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}