将JSON日期/日期(1388624400000)/转换为Excel中的日期 [英] Convert JSON Date /Date(1388624400000)/ to Date in Excel
本文介绍了将JSON日期/日期(1388624400000)/转换为Excel中的日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
解决方案
能够从rel =nofollow noreferrer>这个。
- 假设单元格A1中的字符串/日期(1388624400000)/
- 提取数字部分并将13位数字修剪到前10个,即= MID(A1,8,10);您应该得到:1388624400.将此号码存储在B1
- 然后在C1中,将十六进制数转换为十进制数,带有= hex2dec(B1)。
-
然后使用公式=(C1 / 86400)+ DATE(1970,1,1)
假设日期在A1:
=(Hex2Dec(MID(A1,8,10))/ 86400)+ DATE(1970,1,1)
I have a web extract of data in Excel that has a date column with /Date(1388624400000)/. I need to convert it to date in Excel.
解决方案
Was able to deduce it from here.
- Assume the string /Date(1388624400000)/ is in cell A1
- Extract the number portion and Trim the 13 digit number to the first 10,i.e. =MID(A1,8,10); You should get: 1388624400. store this number in B1
- Then in C1, turn the hex number into a decimal one with =hex2dec(B1).
Then use the formula =(C1/86400)+DATE(1970,1,1)
And for short, assuming the date is in A1:
=(Hex2Dec( MID(A1, 8, 10) ) / 86400) + DATE(1970, 1,1)
这篇关于将JSON日期/日期(1388624400000)/转换为Excel中的日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文