{"id":5094,"date":"2023-07-03T20:06:51","date_gmt":"2023-07-03T20:06:51","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-zamanin-iki-saat-arasinda-olup-olmadigini-kontrol-eder\/"},"modified":"2023-07-03T20:06:51","modified_gmt":"2023-07-03T20:06:51","slug":"excel-zamanin-iki-saat-arasinda-olup-olmadigini-kontrol-eder","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-zamanin-iki-saat-arasinda-olup-olmadigini-kontrol-eder\/","title":{"rendered":"Excel: zaman\u0131n iki saat aras\u0131nda olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir"},"content":{"rendered":"

Belirli bir h\u00fccredeki zaman\u0131n iki belirli zaman aras\u0131nda olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in Excel’de a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n

 =IF(AND( C2<\/span> >=MIN( A2:B2<\/span> ), C2<\/span> <=MAX( A2:B2<\/span> )),\"Yes\",\"No\")\n<\/span><\/span><\/strong><\/pre>\n
 Bu \u00f6zel form\u00fcl, C2<\/strong> h\u00fccresindeki zaman\u0131n A2<\/strong> h\u00fccresindeki ba\u015flang\u0131\u00e7 zaman\u0131 ile B2<\/strong> h\u00fccresindeki biti\u015f zaman\u0131 aras\u0131nda olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve buna g\u00f6re “Evet” veya “Hay\u0131r” de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n
 \u00d6rnek: Excel’de zaman\u0131n iki saat aras\u0131nda olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/strong><\/span><\/h2>\n
 Diyelim ki Excel’de ba\u015flang\u0131\u00e7 ve biti\u015f zamanlar\u0131n\u0131n yan\u0131 s\u0131ra belirli bir olay\u0131n meydana geldi\u011fi zaman\u0131 g\u00f6r\u00fcnt\u00fcleyen a\u015fa\u011f\u0131daki veri k\u00fcmesine sahibiz:<\/span> <\/p>\n
\"\"<\/p>\n
 Her olay\u0131n, her sat\u0131r\u0131n ba\u015flang\u0131\u00e7 ve biti\u015f saatleri aras\u0131nda ger\u00e7ekle\u015fip ger\u00e7ekle\u015fmedi\u011fini belirlemek istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n
 Bunu yapmak i\u00e7in D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n
 =IF(AND( C2<\/span> >=MIN( A2:B2<\/span> ), C2<\/span> <=MAX( A2:B2<\/span> )),\"Yes\",\"No\")<\/span><\/span><\/strong><\/pre>\n
 Daha sonra bu form\u00fcl\u00fc D s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyip doldurabiliriz:<\/span> <\/p>\n
\"Excel<\/p>\n
 S\u00fctun D art\u0131k her olay zaman\u0131n\u0131n, her sat\u0131r\u0131n ba\u015flang\u0131\u00e7 zaman\u0131 ve biti\u015f zaman\u0131 dahilinde olup olmad\u0131\u011f\u0131n\u0131 belirtmek i\u00e7in “Evet” veya “Hay\u0131r”\u0131 g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n
 \u00d6rne\u011fin:<\/span><\/p>\n