{"id":1757,"date":"2023-11-06T22:45:58","date_gmt":"2023-11-06T22:45:58","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/"},"modified":"2023-12-10T06:04:15","modified_gmt":"2023-12-10T06:04:15","slug":"saat-farkini-hesapla","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/","title":{"rendered":"I\u0307ki saat aras\u0131ndaki zaman fark\u0131 nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-302910554\"><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>E\u011fer zaman de\u011ferlerinin oldu\u011fu verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z bug\u00fcn payla\u015faca\u011f\u0131m ipu\u00e7lar\u0131 i\u015finize yarayabilir. \u015eimdi dinle.<\/p><p> Excel&#8217;de tarih ve saati y\u00f6netmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\">bir\u00e7ok i\u015flev vard\u0131r<\/a> . Ancak zaman de\u011ferleri aras\u0131ndaki fark\u0131 elde etmek i\u00e7in kullanabilece\u011finiz \u00f6zel bir i\u015flev yoktur.<\/p><p> Bildi\u011finiz gibi zaman de\u011feri, zaman olarak bi\u00e7imlendirilmi\u015f say\u0131sal bir de\u011ferdir ancak bir de\u011feri di\u011ferinden \u00e7\u0131kard\u0131\u011f\u0131n\u0131zda ondal\u0131k say\u0131 d\u00f6nd\u00fcr\u00fcr ve bunu tekrar zaman olarak bi\u00e7imlendirmeniz gerekir.<\/p><p> Ama ac\u0131 \u015fu:<\/p><p> Bu sonu\u00e7 de\u011ferini formatlad\u0131\u011f\u0131n\u0131zda ger\u00e7ek fark\u0131 saat ve dakika cinsinden g\u00f6stermek yerine bu de\u011ferleri saat ve dakika cinsinden (00:00&#8217;dan ba\u015flayarak) g\u00f6r\u00fcnt\u00fcler.<\/p><p> Yani 5 saat 30 dakika fark\u0131n\u0131z varsa 05:00 olarak g\u00f6sterecektir. Art\u0131k endi\u015felenmenize gerek yok.<\/p><h2 id=\"tab-con-0\" class=\"wp-block-heading\"> 1. Saat ve dakika fark\u0131n\u0131 g\u00f6r\u00fcn<\/h2><p> Bu, iki zaman aras\u0131ndaki fark\u0131 bulman\u0131n en yayg\u0131n yollar\u0131ndan biridir. \u0130kisi aras\u0131ndaki fark\u0131 anlaman\u0131z gereken bir ba\u015flang\u0131\u00e7 ve biti\u015f zaman\u0131n\u0131z (a\u015fa\u011f\u0131daki gibi) oldu\u011funu varsayal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-entre-le-debut-et-la-fin-min.png\" sizes=\"\" srcset=\"\" alt=\"Ba\u015flang\u0131\u00e7 ve biti\u015f aras\u0131ndaki zaman fark\u0131n\u0131 hesaplay\u0131n\"><\/figure><\/div><ol><li> \u00d6ncelikle ba\u015flang\u0131\u00e7 saatinden biti\u015f saatini \u00e7\u0131kard\u0131\u011f\u0131n\u0131zda a\u015fa\u011f\u0131daki gibi bir sonu\u00e7 elde edersiniz. <br><img decoding=\"async\" title=\"hesapla-zaman fark\u0131n\u0131-\u00e7\u0131kar-ba\u015flang\u0131\u00e7-biti\u015f-dakika\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-le-decalage-horaire-deduire-debut-fin-min-1.png\" sizes=\"\" srcset=\"\" alt=\"calculate time difference deduct start end\"><\/li><li> \u015eimdi bu s\u00fcreyi saat ve dakikaya \u00e7evirmeniz gerekiyor.<\/li><li> Bunu yapmak i\u00e7in h\u00fccreyi se\u00e7in ve format se\u00e7eneklerini a\u00e7\u0131n (Ctrl + 1).<\/li><li> Bundan sonra \u201cSaat\u201d kategorisini se\u00e7in ve ikinci saat format\u0131n\u0131 se\u00e7in. <br><img decoding=\"async\" title=\"saat-ve-dakika-dakika cinsinden-zaman fark\u0131n\u0131-bi\u00e7imini hesapla\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-le-format-de-difference-de-temps-en-heure-et-miutes-min.png\" sizes=\"\" srcset=\"\" alt=\"calculate time difference format into hour and minutes\"><\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"zaman kaymas\u0131n\u0131-saat-dakika-dakika-hesapla\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-le-decalage-horaire-heures-miutes-min.png\" sizes=\"\" srcset=\"\" alt=\"calculate time difference hours minutes\"><\/li><\/ol><p> Bunu yapt\u0131\u011f\u0131n\u0131zda, bu saat fark\u0131n\u0131 normal saat format\u0131 yerine saat ve dakikaya d\u00f6n\u00fc\u015ft\u00fcrecektir (Formatlayacakt\u0131r).<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> 2.Saat olarak say\u0131 olarak farkl\u0131 olun<\/h2><p> Bu, zaman fark\u0131 elde etmenin yayg\u0131n bir yolu de\u011fildir, ancak yine de yararl\u0131 ve \u00f6nemlidir. Diyelim ki ba\u015flang\u0131\u00e7 zaman\u0131 ile biti\u015f zaman\u0131 aras\u0131ndaki fark\u0131 saat cinsinden almak istiyorsunuz ama normal rakamlarda de\u011fil.<\/p><p> \u00d6rne\u011fin ba\u015flang\u0131\u00e7 saati ile biti\u015f saati aras\u0131ndaki fark 4 saat 30 dakika ise 4,5 saat olmal\u0131d\u0131r. \u0130\u015fte kullanman\u0131z gereken form\u00fcl. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=(end_time-start_time)*24<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-le-decalage-horaire-en-nombre-dheures-min.png\" sizes=\"\" srcset=\"\" alt=\"saat cinsinden zaman fark\u0131n\u0131 hesapla\"><\/figure><\/div><p> Bu form\u00fcl\u00fc girdi\u011finizde, saatleri rakam olarak ve dakikalar\u0131 (varsa) ondal\u0131k say\u0131 olarak d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h3><p> Daha \u00f6nce de s\u00f6yledi\u011fim gibi Excel, tarih ve saati rakamlarla sakl\u0131yor ve ba\u015flang\u0131\u00e7 saatinden biti\u015f saatini \u00e7\u0131kard\u0131\u011f\u0131n\u0131zda ondal\u0131k say\u0131 d\u00f6nd\u00fcr\u00fcyor. Ve bunu 24 (g\u00fcndeki toplam saat say\u0131s\u0131) ile \u00e7arpt\u0131\u011f\u0131n\u0131zda, bu ondal\u0131k say\u0131y\u0131 saat ve dakika say\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> 3. Tamamlanan saatlerde farkl\u0131 olun<\/h2><p> Bu basit form\u00fclle iki zaman aras\u0131nda tamamlanan saatleri de hesaplayabilirsiniz. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INT((end_time-start_time)*24)<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-le-decalage-horaire-heures-completes-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"saat fark\u0131n\u0131 tam saat olarak hesapla\" width=\"476\" height=\"125\" data-id=\"20762\"><\/p><h3 class=\"wp-block-heading\"> Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h3><p> Bu form\u00fcl ikinci y\u00f6ntemde kulland\u0131\u011f\u0131m\u0131z form\u00fcl\u00fcn ayn\u0131s\u0131d\u0131r, buradaki tek fark onu INT i\u00e7ine sarm\u0131\u015f olmam\u0131zd\u0131r.<\/p><p> INT i\u015flevi, tamsay\u0131 k\u0131sm\u0131n\u0131n ondal\u0131k basama\u011f\u0131n\u0131 a\u015fa\u011f\u0131 yuvarlayarak d\u00f6nd\u00fcr\u00fcr. Daha fazlas\u0131n\u0131 burada bulabilirsiniz. Yani bu form\u00fcl\u00fc girdi\u011finizde \u00f6ncelikle saatlere ili\u015fkin ondal\u0131k say\u0131y\u0131 d\u00f6nd\u00fcr\u00fcr, ard\u0131ndan INT kesirli k\u0131sm\u0131 \u00e7\u0131kar\u0131p size tamamlanan saatleri verir.<\/p><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> 4. Dakikalar i\u00e7inde fark\u0131 yakalay\u0131n<\/h2><p> Zaman fark\u0131n\u0131 saat yerine dakika cinsinden takip etmeniz gereken zamanlar vard\u0131r ve bu durumda en iyi yol a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanmakt\u0131r. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=(end_time-start_time)*1440<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-le-decalage-horaire-en-minutes-min.png\" sizes=\"\" srcset=\"\" alt=\"dakika cinsinden zaman fark\u0131n\u0131 hesapla\"><\/figure><\/div><p> Bu form\u00fclde ba\u015flang\u0131\u00e7 saatini biti\u015f saatinden \u00e7\u0131kard\u0131ktan sonra 24 saat i\u00e7inde sahip oldu\u011fumuz toplam dakika say\u0131s\u0131 olan 1440 ile \u00e7arp\u0131yoruz. Ve bu form\u00fcle girdi\u011finizde sadece birka\u00e7 dakika i\u00e7inde iki de\u011fer aras\u0131ndaki fark\u0131 elde edersiniz.<\/p><p class=\"qt-tip\"> <strong><span style=\"color: #000000;\">\u0130pucu<\/span><\/strong> <span style=\"color: #000000;\">:<\/span> Zaman de\u011ferlerinizde bir \u015fekilde saniyeler varsa, ba\u015flang\u0131\u00e7 zaman\u0131 ile biti\u015f zaman\u0131 aras\u0131ndaki toplam dakika say\u0131s\u0131n\u0131 bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullan\u0131n.<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> 5. Fark\u0131 saniyeler i\u00e7inde \u00f6\u011frenin<\/h2><p> Dakikalar gibi saniyeler i\u00e7inde de fark\u0131 anlayabiliriz. Tek yapman\u0131z gereken a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanmak. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=(end_time-start_time)*86400<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-en-secondes-min.png\" sizes=\"\" srcset=\"\" alt=\"saniye cinsinden zaman fark\u0131n\u0131 hesapla\"><\/figure><\/div><p> Burada 86400 24 saat i\u00e7indeki toplam saniyedir ve bu form\u00fcle girdi\u011finizde ba\u015flang\u0131\u00e7 ve biti\u015f zaman\u0131 aras\u0131ndaki fark\u0131 saniye cinsinden d\u00f6nd\u00fcrecektir.<\/p><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> 6. Fark\u0131 negatif de\u011fer olarak hesaplay\u0131n<\/h2><p> Yukar\u0131daki \u00f6rneklerin t\u00fcm\u00fcnde, ba\u015flang\u0131\u00e7 zaman\u0131ndan daha b\u00fcy\u00fck (daha sonra) bir biti\u015f zaman\u0131m\u0131z var.<\/p><p> Diyelim ki biti\u015f zaman\u0131n\u0131n ba\u015flang\u0131\u00e7 zaman\u0131ndan \u00f6nce oldu\u011fu iki zaman de\u011feriniz var. Basit bir ifadeyle, 1. g\u00fcnde ba\u015flang\u0131\u00e7 saati 23:00 ve 2. g\u00fcnde biti\u015f saati 05:00 ise.<\/p><p> Biti\u015f zaman\u0131 asl\u0131nda ba\u015flang\u0131\u00e7 zaman\u0131ndan daha azd\u0131r ve basit \u00e7\u0131karma form\u00fcl\u00fc \u00e7al\u0131\u015fmaz ve negatif bir de\u011fer d\u00f6nd\u00fcr\u00fcr, bu da Excel&#8217;in bir karma dize (\u00f6rne\u011fin -say ########) g\u00f6r\u00fcnt\u00fclemesine neden olur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-lerreur-de-difference-de-temps-min.png\" sizes=\"\" srcset=\"\" alt=\"saat fark\u0131 hatas\u0131n\u0131 hesapla\"><\/figure><\/div><p> Endi\u015felenmeyin, bunun i\u00e7in daha iyi bir form\u00fcl kullanabilirsiniz. Bu nedenle form\u00fcl \u015f\u00f6yle olacakt\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(end&gt;start, end-start, 1-start+end)<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-valeur-negative-min.png\" sizes=\"auto, \" srcset=\"\" alt=\"zaman fark\u0131n\u0131n negatif de\u011ferini hesaplay\u0131n\" width=\"474\" height=\"124\" data-id=\"20771\"><\/p><h3 class=\"wp-block-heading\"> Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h3><p> Bu form\u00fclde, biti\u015f zaman\u0131 ba\u015flang\u0131\u00e7 zaman\u0131ndan b\u00fcy\u00fckse, biti\u015f zaman\u0131n\u0131 ba\u015flang\u0131\u00e7 zaman\u0131ndan \u00e7\u0131karacak, aksi halde \u00f6nce 1 ba\u015flang\u0131\u00e7 zaman\u0131n\u0131 \u00e7\u0131karacak, sonra bunu biti\u015f zaman\u0131na ekleyecek bir ko\u015fulunuz var.<\/p><p> Ba\u015flang\u0131\u00e7 saatini 1&#8217;den \u00e7\u0131karmak size 1. g\u00fcn\u00fcn toplam s\u00fcresini verecektir ve bunu biti\u015f saatine ekledi\u011finizde 1. g\u00fcn ile 2. g\u00fcn i\u00e7in toplam s\u00fcreyi, yani toplam fark\u0131 elde edersiniz. <\/p><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><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/decalage-horaire-2.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/div><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Zaman verileriyle u\u011fra\u015fan Excel kullan\u0131c\u0131lar\u0131 i\u00e7in iki zaman aras\u0131ndaki fark\u0131 bulmak i\u00e7in farkl\u0131 y\u00f6ntemleri bilmek \u00e7ok \u00f6nemlidir.<\/p><p> Yukar\u0131da kulland\u0131\u011f\u0131m\u0131z t\u00fcm y\u00f6ntemler farkl\u0131 durumlarda kullan\u0131labilir ve eminim hepsini faydal\u0131 bulmu\u015fsunuzdur.<\/p><p> Ama bana bir \u015feyi s\u00f6ylemelisin.<\/p><p> <em>Ba\u015flang\u0131\u00e7 zaman\u0131 ile biti\u015f zaman\u0131 aras\u0131ndaki fark\u0131 bulmak i\u00e7in kullanabilece\u011finiz ba\u015fka bir y\u00f6ntem biliyor musunuz?<\/em><\/p><p> D\u00fc\u015f\u00fcncelerinizi yorum b\u00f6l\u00fcm\u00fcnde benimle payla\u015f\u0131n, sizden haber almay\u0131 ve bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n. <\/p><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><div class=\"wp-block-columns is-layout-flex wp-container-135\"><div class=\"wp-block-column is-layout-flow\"><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-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><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ayri-tarih-ve-saat-2\/\">Excel&#8217;de tarih ve saati ay\u0131rma<\/a><\/li><\/ul><\/div><\/div><\/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-1757","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 iki saat aras\u0131ndaki zaman fark\u0131n\u0131 hesaplay\u0131n?<\/title>\n<meta name=\"description\" content=\"Zaman de\u011ferlerinin oldu\u011fu verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z bug\u00fcn payla\u015faca\u011f\u0131m ipu\u00e7lar\u0131 i\u015finize yarayabilir...\" \/>\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\/saat-farkini-hesapla\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de iki saat aras\u0131ndaki zaman fark\u0131n\u0131 hesaplay\u0131n?\" \/>\n<meta property=\"og:description\" content=\"Zaman de\u011ferlerinin oldu\u011fu verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z bug\u00fcn payla\u015faca\u011f\u0131m ipu\u00e7lar\u0131 i\u015finize yarayabilir...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-entre-le-debut-et-la-fin-min.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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/\",\"name\":\"Excel&#39;de iki saat aras\u0131ndaki zaman fark\u0131n\u0131 hesaplay\u0131n?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-entre-le-debut-et-la-fin-min.png\",\"datePublished\":\"2023-11-06T22:45:58+00:00\",\"dateModified\":\"2023-12-10T06:04:15+00:00\",\"description\":\"Zaman de\u011ferlerinin oldu\u011fu verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z bug\u00fcn payla\u015faca\u011f\u0131m ipu\u00e7lar\u0131 i\u015finize yarayabilir...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-entre-le-debut-et-la-fin-min.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-entre-le-debut-et-la-fin-min.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"I\u0307ki saat aras\u0131ndaki zaman fark\u0131 nas\u0131l hesaplan\u0131r?\"}]},{\"@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 iki saat aras\u0131ndaki zaman fark\u0131n\u0131 hesaplay\u0131n?","description":"Zaman de\u011ferlerinin oldu\u011fu verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z bug\u00fcn payla\u015faca\u011f\u0131m ipu\u00e7lar\u0131 i\u015finize yarayabilir...","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\/saat-farkini-hesapla\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de iki saat aras\u0131ndaki zaman fark\u0131n\u0131 hesaplay\u0131n?","og_description":"Zaman de\u011ferlerinin oldu\u011fu verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z bug\u00fcn payla\u015faca\u011f\u0131m ipu\u00e7lar\u0131 i\u015finize yarayabilir...","og_url":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:15+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-entre-le-debut-et-la-fin-min.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/","url":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/","name":"Excel&#39;de iki saat aras\u0131ndaki zaman fark\u0131n\u0131 hesaplay\u0131n?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-entre-le-debut-et-la-fin-min.png","datePublished":"2023-11-06T22:45:58+00:00","dateModified":"2023-12-10T06:04:15+00:00","description":"Zaman de\u011ferlerinin oldu\u011fu verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z bug\u00fcn payla\u015faca\u011f\u0131m ipu\u00e7lar\u0131 i\u015finize yarayabilir...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-entre-le-debut-et-la-fin-min.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-la-difference-de-temps-entre-le-debut-et-la-fin-min.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"I\u0307ki saat aras\u0131ndaki zaman fark\u0131 nas\u0131l hesaplan\u0131r?"}]},{"@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\/1757","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=1757"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1757\/revisions"}],"predecessor-version":[{"id":2704,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1757\/revisions\/2704"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}