将Excel中的时间戳转换为日期 [英] Converting time stamps in excel to dates
本文介绍了将Excel中的时间戳转换为日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
提前谢谢:)
我不知道任何编程语言
解决方案
使用此公式并将格式设置为所需的时间格式:
=(((COLUMN_ID_HERE / 60)/ 60)/ 24)+ DATE(1970,1,1)
资料来源: http://www.bajb.net/2010/05/excel-timestamp-to-date/
在libreoffice中测试
I have a very large excel spread sheet that has a column of time stamps. Does anyone know convert that over to a date? Is there a function I can use? I tried format cell date but that doesn't work. My file is 91,568 KB. If there is a simpler way to this that would be great. I'm open to ideas.
Thank you in advance :)
P.S.
I don't know any programming languages
解决方案 Use this formula and set formatting to the desired time format:
=(((COLUMN_ID_HERE/60)/60)/24)+DATE(1970,1,1)
Source: http://www.bajb.net/2010/05/excel-timestamp-to-date/
Tested in libreoffice
这篇关于将Excel中的时间戳转换为日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文