{"categories":["Excel"],"version":"1.0","type":"rich","image_url":null,"provider_url":"https://hatena.blog","description":"excel\uff1a1900/1/0 \u304c 0 \u3067\u305d\u3053\u304b\u3089\u306e\u65e5\u6570 unix\uff1a1970/1/1 9:00:00 \u304c 0 \u3067\u305d\u3053\u304b\u3089\u306e\u79d2\u6570 \uff08\u6ce8\uff1aUTC\u3067\u306f\u306a\u304f\u3066JST\uff099\u6642\u9593\u5206\u306e\u79d2\u6570\uff1a60*60*9 = 32400 24\u6642\u9593\u5206\u306e\u79d2\u6570\uff1a60*60*24 = 86400 1970/1/1\u306eexcel\u3067\u306e\u5024\uff1a25569 unix = (excel - 25569) * 86400 - 32400 excel = (unix + 32400) / 86400 + 25569\u4f8b\uff1a2000/1/1\u306e\u5834\u5408 excel\u3067\u306f36526 \u2192 (36526 - 25569) * 86400 -32400 = 946652400\u2026","width":"100%","provider_name":"Hatena Blog","title":"unix(JST)\u3068\u306e\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u5909\u63db","url":"https://katona.hatenadiary.org/entry/20071029/p3","blog_url":"https://katona.hatenadiary.org/","height":"190","published":"2007-10-29 00:00:02","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkatona.hatenadiary.org%2Fentry%2F20071029%2Fp3\" title=\"unix(JST)\u3068\u306e\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u5909\u63db - MEMO:\u306f\u3066\u306a\u652f\u5e97\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"MEMO:\u306f\u3066\u306a\u652f\u5e97","author_url":"https://blog.hatena.ne.jp/katona/","author_name":"katona"}