Posts Tagged"Excel"


如何在Excel中转换Unix epoch时间格式为可读时间格式

Author:  WinkCategories:  SoftwaresNo Comments »

最近在处理从Java项目导出的XML及XLSX文件时,发现导出的文件中,时间均为一长串数字,这其实是Unix epoch时间,即Unix Time。在维基百科上有其解释:

Unix time, or POSIX time, is a system for describing instances in time, defined as the number of seconds that have elapsed since midnight Coordinated Universal Time (UTC), 1 January 1970, not counting leap seconds. It is used widely in Unix-like and many other operating systems and file formats. It is neither a linear representation of time nor a true representation of UTC. Unix time may be checked on some Unix systems by typing date +%s on the command line.



Read the rest of this entry

Back to Page Top