{"id":15450,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/saat\/"},"modified":"2021-02-25T16:28:27","modified_gmt":"2021-02-25T16:28:27","slug":"hour","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/hour\/","title":{"rendered":"SAAT"},"content":{"rendered":"<p>Microsoft Excel ve Google \u0422\u0430\u0431\u043b\u0438\u0446\u0430\u043b\u0430\u0440\u0434\u0430 zamanla ili\u015fkili i\u015flemler yaparken s\u0131k s\u0131k kullan\u0131lan \u00f6nemli fonksiyonlardan biri SAAT (HOUR) fonksiyonudur. Bu fonksiyon, belirtilen zaman\u0131n saat de\u011ferini verir, minutes veya seconds gibi di\u011fer zaman birimlerini almaz. SAAT fonksiyonu genellikle zaman verileri i\u00e7eren veri setlerinde \u00e7al\u0131\u015f\u0131rken zamana dayal\u0131 hesaplamalar yapmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n<h2>Sintaks ve Kullan\u0131m<\/h2>\n<p>SAAT fonksiyonunun temel sintaks\u0131 a\u015fa\u011f\u0131daki gibidir:<\/p>\n<pre> <code> =SAAT(saat_dakika_saniye) <\/code> <\/pre>\n<p>Burada <code>saat_dakika_saniye<\/code> arg\u00fcman\u0131, Excel&#8217;in seri numara format\u0131nda alg\u0131lad\u0131\u011f\u0131 saat, dakika ve saniye bilgilerini i\u00e7eren bir zaman de\u011feridir.<\/p>\n<p>Microsoft Excel \u00f6rne\u011fi:<\/p>\n<pre> <code> =SAAT(\"13:45:30\") <\/code> <\/pre>\n<p>Bu \u00f6rnek, &#8220;13&#8221; sonucunu verecektir \u00e7\u00fcnk\u00fc 13:45:30&#8217;un saat k\u0131sm\u0131 13&#8217;t\u00fcr.<\/p>\n<p>Google \u0422\u0430\u0431\u043b\u0438\u0446\u0430\u043b\u0430\u0440 \u00f6rne\u011fi ayn\u0131 \u015fekilde kullan\u0131l\u0131r:<\/p>\n<pre> <code> =SAAT(\"22:20:55\") <\/code> <\/pre>\n<p>Bu kullan\u0131m, 22 de\u011ferini \u00fcretecek \u00e7\u00fcnk\u00fc 22:20:55&#8217;in saat k\u0131sm\u0131d\u0131r.<\/p>\n<h2>Pratik Uygulama Senaryolar\u0131<\/h2>\n<p>SAAT fonksiyonunun i\u015f d\u00fcnyas\u0131nda ve g\u00fcnl\u00fck kullan\u0131mlarda birka\u00e7 yararl\u0131 uygulamas\u0131 vard\u0131r. \u0130\u015fte baz\u0131 pratik \u00f6rnekler:<\/p>\n<h2>\u00c7al\u0131\u015fma Saatlerinin Hesaplanmas\u0131<\/h2>\n<p>\u00c7al\u0131\u015fanlar\u0131n g\u00fcnl\u00fck \u00e7al\u0131\u015fma saatlerini hesaplama ihtiyac\u0131 oldu\u011funu d\u00fc\u015f\u00fcnelim. Giri\u015f ve \u00e7\u0131k\u0131\u015f zamanlar\u0131n\u0131 i\u00e7eren bir veri setine sahip oldu\u011fumuzu varsayal\u0131m:<\/p>\n<p>Giri\u015f: 9:15:00<br \/> \u00c7\u0131k\u0131\u015f: 17:45:00<\/p>\n<p>\u00c7al\u0131\u015fma saatinin hesaplanmas\u0131:<\/p>\n<pre> <code> =SAAT(F2)-SAAT(E2) <\/code> <\/pre>\n<p>burada E2 h\u00fccresi giri\u015f zaman\u0131, F2 h\u00fccresi \u00e7\u0131k\u0131\u015f zaman\u0131d\u0131r. Bu \u00f6rnek, iki zaman aras\u0131ndaki fark\u0131 saat cinsinden verir ve \u00e7al\u0131\u015f\u0131lan toplam saati (8 saat) hesaplar.<\/p>\n<h2>Zaman Aral\u0131klar\u0131nda Sorgulama<\/h2>\n<p>Bir ba\u015fka kullan\u0131m, belli zaman aral\u0131klar\u0131na g\u00f6re veri filtrelemek olabilir. \u00d6rne\u011fin, belli saatlerde ger\u00e7ekle\u015fen i\u015flemleri sorgulamak isteyebilirsiniz:<\/p>\n<pre> <code> =E\u011eER(VE(SAAT(A2) &gt;= 12, SAAT(A2) &lt;= 17), \"\u00d6\u011fleden Sonra\", \"Di\u011fer\") <\/code> <\/pre>\n<p>Bu form\u00fcl A2 h\u00fccresindeki zaman\u0131n saat 12 ile 17 aras\u0131nda olup olmad\u0131\u011f\u0131n\u0131 kontrol eder. E\u011fer bu saatler aras\u0131nda ise &#8220;\u00d6\u011fleden Sonra&#8221; de\u011fil ise &#8220;Di\u011fer&#8221; sonucunu \u00fcretir.<\/p>\n<p>Yukar\u0131da verilen \u00e7\u00f6z\u00fcmler ve \u00f6neriler, SAAT fonksiyonunun nas\u0131l kullan\u0131labilece\u011fini g\u00f6stermektedir. Bu \u00f6zellikle zaman verileriyle \u00e7al\u0131\u015fan Excel ve Google \u0422\u0430\u0431\u043b\u0438\u0446\u0430\u043b\u0430\u0440 kullan\u0131c\u0131lar\u0131 i\u00e7in b\u00fcy\u00fck kolayl\u0131klar sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir seri numaras\u0131n\u0131 saate d\u00f6n\u00fc\u015ft\u00fcr\u00fcr<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[588],"tags":[],"class_list":["post-15450","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de HOUR (SAAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da HOUR (SAAT) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/hour\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de HOUR (SAAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da HOUR (SAAT) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/hour\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:28:27+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de HOUR (SAAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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:\/\/functiontranslator.com\/tr\/hour\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/hour\/\",\"name\":\"Excel'de HOUR (SAAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:28:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da HOUR (SAAT) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/hour\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/hour\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/hour\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tarih ve saat\",\"item\":\"https:\/\/functiontranslator.com\/tr\/tarih-ve-saat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SAAT\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de HOUR (SAAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da HOUR (SAAT) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/hour\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de HOUR (SAAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da HOUR (SAAT) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/hour\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:28:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de HOUR (SAAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/hour\/","url":"https:\/\/functiontranslator.com\/tr\/hour\/","name":"Excel'de HOUR (SAAT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:28:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da HOUR (SAAT) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/hour\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/hour\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/hour\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Tarih ve saat","item":"https:\/\/functiontranslator.com\/tr\/tarih-ve-saat\/"},{"@type":"ListItem","position":3,"name":"SAAT"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15450"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15450\/revisions"}],"predecessor-version":[{"id":26718,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15450\/revisions\/26718"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}