{"id":5022,"date":"2023-07-05T01:17:03","date_gmt":"2023-07-05T01:17:03","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/"},"modified":"2023-07-05T01:17:03","modified_gmt":"2023-07-05T01:17:03","slug":"excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/","title":{"rendered":"Excel: gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saatleri hesaplay\u0131n"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Genellikle Excel&#8217;de gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saat say\u0131s\u0131n\u0131 hesaplamak isteyebilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=( <span style=\"color: #3366ff;\">B2<\/span> - <span style=\"color: #ff0000;\">A2<\/span> +TRUE)*24<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bu \u00f6zel \u00f6rnek, <strong>A2<\/strong> h\u00fccresindeki ba\u015flang\u0131\u00e7 zaman\u0131 ile <strong>B2<\/strong> h\u00fccresindeki biti\u015f zaman\u0131 aras\u0131ndaki saat say\u0131s\u0131n\u0131, bu iki saat aras\u0131nda gece yar\u0131s\u0131n\u0131n meydana geldi\u011fini varsayarak hesaplar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: Excel&#8217;de gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki s\u00fcreleri hesaplama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;deki baz\u0131 g\u00f6revler i\u00e7in a\u015fa\u011f\u0131daki ba\u015flang\u0131\u00e7 ve biti\u015f zaman\u0131 listelerine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39145 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minuit1.png\" alt=\"\" width=\"429\" height=\"400\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Gece yar\u0131s\u0131n\u0131n her ba\u015flang\u0131\u00e7 ve biti\u015f zaman\u0131 aras\u0131nda ger\u00e7ekle\u015fti\u011fini unutmay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u0130lk ba\u015flang\u0131\u00e7 saati ile ilk biti\u015f saati aras\u0131ndaki saat fark\u0131n\u0131 hesaplamak i\u00e7in <strong>C2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=( <span style=\"color: #3366ff;\">B2<\/span> - <span style=\"color: #ff0000;\">A2<\/span> +TRUE)*24<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39146\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minuit2.png\" alt=\"Excel gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki s\u00fcreyi hesaplar\" width=\"479\" height=\"407\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">C S\u00fctunu art\u0131k her sat\u0131r\u0131n ba\u015flang\u0131\u00e7 zaman\u0131 ile biti\u015f zaman\u0131 aras\u0131ndaki saat cinsinden fark\u0131 g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">16:15 ile 04:13 aras\u0131ndaki fark <strong>11,97<\/strong> saattir.<\/span><\/li>\n<li> <span style=\"color: #000000;\">17:19 ile 05:00 aras\u0131ndaki fark <strong>11,68<\/strong> saattir.<\/span><\/li>\n<li> <span style=\"color: #000000;\">18:00 ile 05:15 aras\u0131ndaki fark <strong>11:25&#8217;tir<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ve benzeri.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Not<\/strong> : Form\u00fcl\u00fcn\u00fcz ondal\u0131k saat say\u0131s\u0131 yerine saat de\u011ferini d\u00f6nd\u00fcr\u00fcyorsa, <strong>C2:C10<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulaman\u0131z, ard\u0131ndan Giri\u015f sekmesindeki <strong>Say\u0131 Bi\u00e7imi<\/strong> a\u00e7\u0131l\u0131r men\u00fcs\u00fcn\u00fc t\u0131klatman\u0131z ve ard\u0131ndan <strong>Genel&#8217;i<\/strong> t\u0131klatman\u0131z gerekir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39147 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/format_general.png\" alt=\"\" width=\"559\" height=\"168\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu, zaman bi\u00e7imindeki t\u00fcm de\u011ferleri ondal\u0131k say\u0131sal bi\u00e7ime d\u00f6n\u00fc\u015ft\u00fcrecektir.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Ek kaynaklar<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/tr\/excel-zamani-dakikaya-cevirme\/\" target=\"_blank\" rel=\"noopener\">Excel: S\u00fcreyi dakikaya d\u00f6n\u00fc\u015ft\u00fcrme<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/dakika-cinsinden-zaman-arasindaki-excel-farki\/\" target=\"_blank\" rel=\"noopener\">Excel: iki zaman aras\u0131ndaki fark\u0131 dakika cinsinden hesaplay\u0131n<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/saat-cinsinden-saatler-arasindaki-excel-farki\/\" target=\"_blank\" rel=\"noopener\">Excel: iki saat aras\u0131ndaki fark\u0131 saat cinsinden hesaplay\u0131n<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Genellikle Excel&#8217;de gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saat say\u0131s\u0131n\u0131 hesaplamak isteyebilirsiniz. Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =( B2 &#8211; A2 +TRUE)*24 Bu \u00f6zel \u00f6rnek, A2 h\u00fccresindeki ba\u015flang\u0131\u00e7 zaman\u0131 ile B2 h\u00fccresindeki biti\u015f zaman\u0131 aras\u0131ndaki saat say\u0131s\u0131n\u0131, bu iki saat aras\u0131nda gece yar\u0131s\u0131n\u0131n meydana geldi\u011fini varsayarak hesaplar. A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 [&hellip;]<\/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":[],"class_list":["post-5022","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saatleri hesaplay\u0131n - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#039;de gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki s\u00fcrelerin nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saatleri hesaplay\u0131n - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#039;de gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki s\u00fcrelerin nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T01:17:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minuit1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/\",\"name\":\"Excel: Gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saatleri hesaplay\u0131n - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-05T01:17:03+00:00\",\"dateModified\":\"2023-07-05T01:17:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;de gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki s\u00fcrelerin nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saatleri hesaplay\u0131n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saatleri hesaplay\u0131n - Statorials","description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;de gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki s\u00fcrelerin nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","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\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: Gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saatleri hesaplay\u0131n - Statorials","og_description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;de gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki s\u00fcrelerin nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/","og_site_name":"Statorials","article_published_time":"2023-07-05T01:17:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minuit1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/","url":"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/","name":"Excel: Gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saatleri hesaplay\u0131n - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-05T01:17:03+00:00","dateModified":"2023-07-05T01:17:03+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;de gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki s\u00fcrelerin nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-gece-yarisindan-sonraki-iki-saat-arasindaki-saatleri-hesaplamak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: gece yar\u0131s\u0131ndan sonraki iki saat aras\u0131ndaki saatleri hesaplay\u0131n"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/5022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=5022"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/5022\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=5022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=5022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=5022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}