{"id":401,"date":"2010-12-17T14:21:00","date_gmt":"2010-12-17T13:21:00","guid":{"rendered":"http:\/\/www.matjazev.net\/blog\/?p=401"},"modified":"2010-12-17T14:21:00","modified_gmt":"2010-12-17T13:21:00","slug":"oblikovanje-celic-v-excelu-kode-za-datum-in-cas","status":"publish","type":"post","link":"https:\/\/www.matjazev.net\/blog\/2010\/12\/17\/oblikovanje-celic-v-excelu-kode-za-datum-in-cas\/","title":{"rendered":"Oblikovanje celic v Excelu &#8211; kode za datum in \u010das"},"content":{"rendered":"<p><a href=\"http:\/\/www.matjazev.net\/blog\/2010\/12\/09\/oblikovanje-celic-v-excelu-%E2%80%93-numericne-kode\/\">V enem izmed prej\u0161njih prispevkov<\/a> smo si ogledali kako lahko v Excelu definirate lasten izgled podatkov v celicah. V omenjenem prispevku pa smo se omejili samo na dolo\u010danje oblike numeri\u010dnih podatkov.<\/p>\n<p>Seveda pa pozna Excel tudi posebne <strong>kode za oblikovanje datumov in \u010dasov <\/strong>in v tem prispevku si bomo zatorej ogledali slednje.<\/p>\n<h3>Oblikovni znaki za datume in \u010dase<\/h3>\n<p>Tabela oblikovnih znakov za datume:<\/p>\n<table cellspacing=\"5\" cellpadding=\"5\" frame=\"box\">\n<tbody>\n<tr>\n<th>Znak<\/th>\n<th>Pomen<\/th>\n<\/tr>\n<tr>\n<td><strong>m<\/strong><\/td>\n<td>Izpi\u0161e mesec brez vodilne ni\u010dle, torej 1 do 12<\/td>\n<\/tr>\n<tr>\n<td><strong>mm<\/strong><\/td>\n<td>Izpi\u0161e mesec z vodilno ni\u010dlo, torej 01 do 12<\/td>\n<\/tr>\n<tr>\n<td><strong>mmm<\/strong><\/td>\n<td>Izpi\u0161e tri\u010drkovno okraj\u0161avo za mesec, torej jan do dec<\/td>\n<\/tr>\n<tr>\n<td><strong>mmmm<br \/>\n<\/strong><\/td>\n<td>Izpi\u0161e ime meseca januar do december<\/td>\n<\/tr>\n<tr>\n<td><strong>d<br \/>\n<\/strong><\/td>\n<td>Izpi\u0161e dan v mesecu brez vodilne ni\u010dle, torej 1 to 31<\/td>\n<\/tr>\n<tr>\n<td><strong>dd<br \/>\n<\/strong><\/td>\n<td>Izpi\u0161e dan v mesecu z vodilno ni\u010dlo, torej 01 to 31<\/td>\n<\/tr>\n<tr>\n<td><strong>ddd<br \/>\n<\/strong><\/td>\n<td>Izpi\u0161e tri\u010drkovno okraj\u0161avo za dan v tednu(!), torej pon do ned<\/td>\n<\/tr>\n<tr>\n<td><strong>dddd<br \/>\n<\/strong><\/td>\n<td>Izpi\u0161e dan v tednu(!), torej ponedeljek do nedelja<\/td>\n<\/tr>\n<tr>\n<td><strong>yy<br \/>\n<\/strong><\/td>\n<td>Izpi\u0161e dvomestno leto (torej brez 20 iz 19 spredaj)<\/td>\n<\/tr>\n<tr>\n<td><strong>yyyy<br \/>\n<\/strong><\/td>\n<td>Izpi\u0161e vse 4 cifre v letu<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Tabela oblikovnih znakov za \u010dase:<\/p>\n<table cellspacing=\"5\" cellpadding=\"5\" frame=\"box\">\n<tbody>\n<tr>\n<th>Znak<\/th>\n<th>Pomen<\/th>\n<\/tr>\n<tr>\n<td><strong>s<\/strong><\/td>\n<td>Sekunde brez vodilnih ni\u010del 0 do 59<\/td>\n<\/tr>\n<tr>\n<td><strong>ss<\/strong><\/td>\n<td>Sekunde z vodilnimi ni\u010dlami 00 do 59<\/td>\n<\/tr>\n<tr>\n<td><strong>m<\/strong><\/td>\n<td>Minute brez vodilnih ni\u010del 0 do 59<\/td>\n<\/tr>\n<tr>\n<td><strong>mm<br \/>\n<\/strong><\/td>\n<td>Minute z vodilnimi ni\u010dlami 00 do 59<\/td>\n<\/tr>\n<tr>\n<td><strong>h<br \/>\n<\/strong><\/td>\n<td>Ure brez vodilnih ni\u010del 0 do 23<\/td>\n<\/tr>\n<tr>\n<td><strong>hh<br \/>\n<\/strong><\/td>\n<td>Ure z vodilnimi ni\u010dlami 00 do 23<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Primeri<\/h3>\n<p>Ker je razlaga suhoparna sem vam spet pripravil datoteko, <a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/oblika_celic.xls\">kjer se lahko po mili volji igrate z nastavitvami<\/a> &#8230; \ud83d\ude42<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/12\/oblika_celic.xls\">&lt;datoteka s primeri&gt;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V enem izmed prej\u0161njih prispevkov smo si ogledali kako lahko v Excelu definirate lasten izgled podatkov v celicah. V omenjenem prispevku pa smo se omejili samo na dolo\u010danje oblike numeri\u010dnih podatkov. Seveda pa pozna Excel tudi posebne kode za oblikovanje datumov in \u010dasov in v tem prispevku si bomo zatorej ogledali slednje. Oblikovni znaki za &hellip; <a href=\"https:\/\/www.matjazev.net\/blog\/2010\/12\/17\/oblikovanje-celic-v-excelu-kode-za-datum-in-cas\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Oblikovanje celic v Excelu &#8211; kode za datum in \u010das<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,3,19],"tags":[32,14,9,61,33,22,30],"_links":{"self":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/401"}],"collection":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/comments?post=401"}],"version-history":[{"count":9,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/401\/revisions"}],"predecessor-version":[{"id":425,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/401\/revisions\/425"}],"wp:attachment":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/media?parent=401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/categories?post=401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/tags?post=401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}