{"id":1725,"date":"2023-11-09T17:04:53","date_gmt":"2023-11-09T17:04:53","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/"},"modified":"2023-12-10T06:03:25","modified_gmt":"2023-12-10T06:03:25","slug":"sekerleme-zamani-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/","title":{"rendered":"Excel&#39;de zaman nas\u0131l eklenir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3584063164\"><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>Excel&#8217;de zaman de\u011ferlerini toplamak istiyorsan\u0131z, de\u011ferleri toplamak i\u00e7in toplam i\u015flevini kullanman\u0131z ve ard\u0131ndan toplam saat ve dakika say\u0131s\u0131n\u0131 g\u00f6sterecek \u015fekilde bi\u00e7imi de\u011fi\u015ftirmeniz gerekir. A\u015fa\u011f\u0131da C2 h\u00fccresinde birlikte ekledi\u011fimiz zaman de\u011ferlerinin bir listesi bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79498\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel'de saat toplam\u0131\" width=\"573\" height=\"347\"><\/figure><\/div><p> Bu derste bu form\u00fcl\u00fcn nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 ve ona do\u011fru format\u0131n nas\u0131l uygulanaca\u011f\u0131n\u0131 \u00f6\u011freniyoruz.<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de Zaman Eklemek \u0130\u00e7in Form\u00fcl Yaz\u0131n<\/h2><ol type=\"1\"><li> \u00d6ncelikle C2 h\u00fccresine toplam fonksiyonunu girin.<\/li><li> \u015eimdi ba\u015flang\u0131\u00e7 parantezlerini girin.<\/li><li> Bundan sonra zaman de\u011ferlerinin bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131na bak\u0131n.<\/li><li> Sonunda kapatma parantezlerini girin ve sonucu almak i\u00e7in Enter tu\u015funa bas\u0131n.<\/li><\/ol><p> Bu size de\u011ferlerin toplam\u0131n\u0131 verecektir ancak bu format do\u011fru de\u011fil ve bu format\u0131 \u00f6zel format kullanarak de\u011fi\u015ftirmemiz gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79499\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formule-pour-additionner-le-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"zaman\u0131 toplama form\u00fcl\u00fc\" width=\"571\" height=\"346\"><\/figure><\/div><ol type=\"1\"><li> H\u00fccreyi se\u00e7erken klavye k\u0131sayolu (Ctrl+1) ile format se\u00e7ene\u011fini a\u00e7\u0131n.<\/li><li> \u015eimdi \u00d6zel se\u00e7ene\u011fine t\u0131klay\u0131n.<\/li><li> Bundan sonra format giri\u015f \u00e7ubu\u011funa t\u0131klay\u0131n.<\/li><li> Daha sonra giri\u015f \u00e7ubu\u011funa [h]:mm de\u011ferini girin.<\/li><li> Sonunda bi\u00e7imlendirmeyi uygulamak i\u00e7in Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79500\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-changer-le-format-de-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccre-format\u0131n\u0131 de\u011fi\u015ftir\" width=\"570\" height=\"562\"><\/figure><\/div><p> Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131z anda size toplam saat ve dakikalar\u0131 g\u00f6sterecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79501\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nombre-total-dheures-et-de-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplam saat ve dakika say\u0131s\u0131\" width=\"577\" height=\"349\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Bunu anlamal\u0131s\u0131n<\/h2><p> Excel, tarih ve saati arka u\u00e7ta bir say\u0131 olarak saklar ve h\u00fccrede format bulunur. Yani zaman de\u011ferlerinizi de\u011ferlere \u00e7evirirseniz a\u015fa\u011f\u0131daki gibi g\u00f6r\u00fcnecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79502\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-comprendre-les-valeurs-temporelles.png\" sizes=\"auto, \" srcset=\"\" alt=\"zaman de\u011ferlerini anlay\u0131n\" width=\"306\" height=\"325\"><\/figure><\/div><p> <strong>Zaman de\u011ferleri her zaman ondal\u0131k say\u0131larla ifade edilir.<\/strong><\/p><p> Art\u0131k bu de\u011ferleri ekledi\u011finizde sonu\u00e7ta 1,4375 de\u011feri \u00e7\u0131k\u0131yor.<\/p><p> Dedi\u011fim gibi zaman de\u011ferleri her zaman ondal\u0131k say\u0131larla ifade edilir, zaman format\u0131n\u0131 (normal saat format\u0131 SS:DD AM\/PM) uygulad\u0131\u011f\u0131n\u0131zda Excel size zaman\u0131 kalan 0,4375 olan ondal\u0131k de\u011fere g\u00f6re g\u00f6sterir ve tamsay\u0131 olarak kabul edersiniz. tam g\u00fcn olarak 1&#8217;dir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79503\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-valeurs-de-temps-toujours-en-decimal.png\" sizes=\"auto, \" srcset=\"\" alt=\"zaman-de\u011ferleri-her zaman-ondal\u0131k olarak\" width=\"343\" height=\"395\"><\/figure><\/div><p> Bu sorunun \u00fcstesinden gelmek i\u00e7in y\u00f6ntemimizde kulland\u0131\u011f\u0131m\u0131z \u00f6zel bir format\u0131 kullanman\u0131z gerekir. Formatla parantez ekledi\u011finizde sonu\u00e7ta toplam saat g\u00f6r\u00fcnt\u00fclenir. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">[h]:mm<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79504\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-format-personnalise-pour-le-nombre-total-dheures.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplam-saat-i\u00e7in-\u00f6zel-bi\u00e7im\" width=\"473\" height=\"299\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/temps-de-somme.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a> <\/div><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Daha fazla form\u00fcl<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zamana-saat-ekleyin\/\">Excel&#8217;de zamana saat ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zamana-dakika-ekleyin\/\">Excel&#8217;de zamana dakika ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/\">Excel&#8217;de iki saat aras\u0131ndaki zaman fark\u0131n\u0131 hesaplay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/saat-formatini-degistir\/\">Excel&#8217;de saat bi\u00e7imini de\u011fi\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/askeri-zaman\/\">Excel&#8217;de askeri s\u00fcre (alma ve \u00e7\u0131karma)<\/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-1725","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>Excel&#039;de zaman nas\u0131l eklenir? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Bu dersimizde Excel&#039;de bir h\u00fccre aral\u0131\u011f\u0131n\u0131n zaman de\u011ferlerini toplamak i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz.\" \/>\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\/tr\/sekerleme-zamani-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de zaman nas\u0131l eklenir? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu dersimizde Excel&#039;de bir h\u00fccre aral\u0131\u011f\u0131n\u0131n zaman de\u011ferlerini toplamak i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:03:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/\",\"name\":\"Excel&#39;de zaman nas\u0131l eklenir? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png\",\"datePublished\":\"2023-11-09T17:04:53+00:00\",\"dateModified\":\"2023-12-10T06:03:25+00:00\",\"description\":\"Bu dersimizde Excel&#39;de bir h\u00fccre aral\u0131\u011f\u0131n\u0131n zaman de\u011ferlerini toplamak i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de zaman nas\u0131l eklenir?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de zaman nas\u0131l eklenir? (E\u011fitim 2023)","description":"Bu dersimizde Excel&#39;de bir h\u00fccre aral\u0131\u011f\u0131n\u0131n zaman de\u011ferlerini toplamak i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz.","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\/tr\/sekerleme-zamani-2\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de zaman nas\u0131l eklenir? (E\u011fitim 2023)","og_description":"Bu dersimizde Excel&#39;de bir h\u00fccre aral\u0131\u011f\u0131n\u0131n zaman de\u011ferlerini toplamak i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz.","og_url":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:03:25+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/","url":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/","name":"Excel&#39;de zaman nas\u0131l eklenir? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png","datePublished":"2023-11-09T17:04:53+00:00","dateModified":"2023-12-10T06:03:25+00:00","description":"Bu dersimizde Excel&#39;de bir h\u00fccre aral\u0131\u011f\u0131n\u0131n zaman de\u011ferlerini toplamak i\u00e7in form\u00fcl yazmay\u0131 \u00f6\u011frenece\u011fiz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-temps-de-somme-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de zaman nas\u0131l eklenir?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1725","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1725"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1725\/revisions"}],"predecessor-version":[{"id":2652,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1725\/revisions\/2652"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}