内容来源于 Stack Overflow,并遵循CC BY-SA 3.0许可协议进行翻译与使用
有人知道如何将Excel日期转换为正确的Unix时间戳吗?
Windows和Mac Excel(2011):
Unix Timestamp = (Excel Timestamp - 25569) * 86400 Excel Timestamp = (Unix Timestamp / 86400) + 25569
Mac OS X(2007):
Unix Timestamp = (Excel Timestamp - 24107) * 86400 Excel Timestamp = (Unix Timestamp / 86400) + 24107
供参考:
86400 = Seconds in a day 25569 = Days between 1970/01/01 and 1900/01/01 (min date in Windows Excel) 24107 = Days between 1970/01/01 and 1904/01/02 (min date in Mac Excel 2007)