{"id":3808,"date":"2023-07-15T10:34:34","date_gmt":"2023-07-15T10:34:34","guid":{"rendered":"https:\/\/statorials.org\/tr\/google-sayfalarinin-ondalik-zamani\/"},"modified":"2023-07-15T10:34:34","modified_gmt":"2023-07-15T10:34:34","slug":"google-sayfalarinin-ondalik-zamani","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/google-sayfalarinin-ondalik-zamani\/","title":{"rendered":"Google e-tablolar: zaman\u0131 h\u0131zla ondal\u0131k say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fcn"},"content":{"rendered":"

<\/p>\n

\n

Google E-Tablolar’da bir zaman\u0131 ondal\u0131k de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n

 =<\/span> HOUR<\/span> (<\/span> B2<\/span> )<\/span> +<\/span> (<\/span> MINUTE<\/span> (<\/span> B2<\/span> )<\/span> \/<\/span> 60<\/span> )<\/span> +<\/span> (<\/span> SECOND<\/span> (<\/span> B2<\/span> )<\/span> \/<\/span> 3600<\/span> )<\/span>\n<\/strong><\/span><\/pre>\n
 Bu \u00f6zel form\u00fcl, B2 h\u00fccresindeki zaman\u0131 ondal\u0131k de\u011fere d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/span><\/p>\n
 \u00d6rne\u011fin, saat 4:19:34<\/strong> ise form\u00fcl bunu 4,3261’e<\/strong> d\u00f6n\u00fc\u015ft\u00fcrecek ve b\u00f6ylece saat 4,3261 saat olarak temsil edilecektir.<\/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: Google E-Tablolar’da zaman\u0131 ondal\u0131k say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrme<\/strong><\/span><\/h2>\n
 Google E-Tablolar’da, farkl\u0131 sporcular\u0131n bir yar\u0131\u015fmay\u0131 tamamlamak i\u00e7in harcad\u0131\u011f\u0131 saat, dakika ve saniye say\u0131s\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n
\"\"<\/p>\n
 S\u00fcreleri ondal\u0131k formata d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/span><\/p>\n
 =<\/span> HOUR<\/span> (<\/span> B2<\/span> )<\/span> +<\/span> (<\/span> MINUTE<\/span> (<\/span> B2<\/span> )<\/span> \/<\/span> 60<\/span> )<\/span> +<\/span> (<\/span> SECOND<\/span> (<\/span> B2<\/span> )<\/span> \/<\/span> 3600<\/span> )<\/span><\/strong><\/span><\/pre>\n
 Bu form\u00fcl\u00fc C2<\/strong> h\u00fccresine yazaca\u011f\u0131z, ard\u0131ndan form\u00fcl\u00fc t\u0131klay\u0131p C s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyece\u011fiz:<\/span> <\/p>\n
\"Google<\/p>\n
 Yeni Ondal\u0131k<\/strong> s\u00fctunu, S\u00fcre<\/strong> s\u00fctunundaki zaman\u0131 ondal\u0131k bi\u00e7imde g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n
 \u00d6rne\u011fin:<\/span><\/p>\n