{"id":15680,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/zaman\/"},"modified":"2021-02-25T16:37:38","modified_gmt":"2021-02-25T16:37:38","slug":"time","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/time\/","title":{"rendered":"ZAMAN"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, i\u015f ve \u00f6\u011frenme faaliyetlerinde s\u0131kl\u0131kla kullan\u0131lan elektronik tablo uygulamalar\u0131d\u0131r. Her iki platformda da yer alan ZAMAN fonksiyonu, belirlenen saati, dakikay\u0131 ve saniyeyi Excel’in tarih-saat format\u0131na \u00e7evirmek i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, zaman odakl\u0131 hesaplamalar\u0131 ger\u00e7ekle\u015ftirirken b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r.<\/p>\n

ZAMAN Fonksiyonunun S\u00f6zdizimi<\/h2>\n

ZAMAN fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p>\n

=ZAMAN(saat, dakika, saniye)<\/code><\/pre>\n
    \n
  • saat:<\/strong> G\u00fcn\u00fcn saati i\u00e7in kullan\u0131lan de\u011fer. 0 (gece yar\u0131s\u0131) ve 23 (gece sonu) aras\u0131nda olmal\u0131d\u0131r.<\/li>\n
  • dakika:<\/strong> Dakika de\u011feri. 0 ile 59 aras\u0131nda olmal\u0131d\u0131r.<\/li>\n
  • saniye:<\/strong> Saniye de\u011feri. 0 ile 59 aras\u0131nda olmal\u0131d\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
    =ZAMAN(14, 30, 0)<\/code><\/pre>\n
    Bu form\u00fcl, saat 14:30:00’\u0131 ifade eder.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    ZAMAN fonksiyonu, farkl\u0131 ger\u00e7ek d\u00fcnya senaryolar\u0131nda etkili bir \u015fekilde kullan\u0131labilir. \u0130\u015fte birka\u00e7 uygulama \u00f6rne\u011fi:<\/p>\n
    \u00c7al\u0131\u015fma Saatlerinin Hesaplanmas\u0131<\/h2>\n
    Bir \u015firkette bir \u00e7al\u0131\u015fan\u0131n g\u00fcnl\u00fck \u00e7al\u0131\u015fma zaman\u0131n\u0131 hesaplamak gerekirse, \u00e7al\u0131\u015fan\u0131n i\u015fe ba\u015flang\u0131\u00e7 saati sabah 09:15, biti\u015f saati ise ak\u015fam 17:45 olabilir. \u00c7al\u0131\u015fma s\u00fcresini hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131labilir:<\/p>\n
    =ZAMAN(17, 45, 0) - ZAMAN(9, 15, 0)<\/code><\/pre>\n
    Bu form\u00fcl, otomatik olarak sonucu saat cinsinden verir ve \u00e7al\u0131\u015fan\u0131n toplam \u00e7al\u0131\u015fma s\u00fcresi 8 saat 30 dakika (8,5 saat) olarak hesaplan\u0131r.<\/p>\n
    Zaman Aral\u0131klar\u0131n\u0131n Toplanmas\u0131<\/h2>\n
    Bir etkinlik planlay\u0131c\u0131s\u0131, farkl\u0131 oturumlar i\u00e7in gereken toplam s\u00fcreyi hesaplamak isteyebilir. \u00d6rne\u011fin, ilk oturum 45 dakika, ikinci oturum 30 dakika, \u00fc\u00e7\u00fcnc\u00fc oturum ise 25 dakika s\u00fcrmektedir. Toplam s\u00fcreyi hesaplamak i\u00e7in \u015fu form\u00fcl kullan\u0131l\u0131r:<\/p>\n
    =ZAMAN(0, 45, 0) + ZAMAN(0, 30, 0) + ZAMAN(0, 25, 0)<\/code><\/pre>\n
    Bu hesaplama, toplamda 1 saat 40 dakika s\u00fcre verir ve sonu\u00e7 dakika ve saat olarak do\u011fru bi\u00e7imde g\u00f6sterilir.<\/p>\n
    Excel ve Google Sheets’teki ZAMAN fonksiyonu, zaman verileri \u00fczerinde \u00e7al\u0131\u015f\u0131rken olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r ve zamanla ilgili hesaplamalar i\u00e7in m\u00fckemmel bir ara\u00e7t\u0131r. Bu fonksiyon, i\u015f, e\u011fitim ya da ki\u015fisel zaman y\u00f6netimi gibi \u00e7e\u015fitli alanlarda etkili bir \u00e7\u00f6z\u00fcmd\u00fcr.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Belirli bir zaman\u0131n seri numaras\u0131n\u0131 verir<\/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-15680","post","type-post","status-publish","format-standard","hentry","category-tarih-ve-saat"],"acf":[],"yoast_head":"\nExcel'de TIME (ZAMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TIME (ZAMAN) 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\/time\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TIME (ZAMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TIME (ZAMAN) 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\/time\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:37:38+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de TIME (ZAMAN) 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\/time\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/time\/\",\"name\":\"Excel'de TIME (ZAMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:37:38+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TIME (ZAMAN) 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\/time\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/time\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/time\/#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\":\"ZAMAN\"}]},{\"@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 TIME (ZAMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TIME (ZAMAN) 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\/time\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TIME (ZAMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TIME (ZAMAN) 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\/time\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:37:38+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TIME (ZAMAN) 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\/time\/","url":"https:\/\/functiontranslator.com\/tr\/time\/","name":"Excel'de TIME (ZAMAN) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:37:38+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TIME (ZAMAN) 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\/time\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/time\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/time\/#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":"ZAMAN"}]},{"@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\/15680","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=15680"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15680\/revisions"}],"predecessor-version":[{"id":26948,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15680\/revisions\/26948"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}