excelï¼1900/1/0 ã 0 ã§ããããã®æ¥æ° unixï¼1970/1/1 9:00:00 ã 0 ã§ããããã®ç§æ° ï¼æ³¨ï¼UTCã§ã¯ãªãã¦JSTï¼ 9æéåã®ç§æ°ï¼60*60*9 = 32400 24æéåã®ç§æ°ï¼60*60*24 = 86400 1970/1/1ã®excelã§ã®å¤ï¼25569 unix = (excel - 25569) * 86400 - 32400 excel = (unix + 32400) / 86400 + 25569ä¾ï¼2000/1/1ã®å ´å excelã§ã¯36526 â (36526 - 25569) * 86400 -32400 = 946652400 unixã§ã¯946652400 â (946652400 + 32400) / 86400 + 25569 = 36526
{{#tags}}- {{label}}
{{/tags}}