I’m trying to convert Unix time exported from the graph. Found existing numbers contain extra three zeros at the end.
Those are milliseconds from 1970
How I still can convert to human time in excel ?.
Please use google next time…
also a search of this site with “Excel Date” brings up Data format in History Graph
Please do it on your own and get a result before refer to link which I read twice before asked this question. I tried all methods and wasn’t able to convert a unix timestamp to date.
Even on mac it’s impossible:
And I’m still insisting on unnecessary have last three zeros at the and of timestamp, other way somebody can explain wat I’m doing wrong to convert Unix time.
I don’t have this probem. My CSV doesnt have the extra 0’s hense the tutorial works fine.
milliseconds in a second = 1000
as pointed out by @eugene you are seeing “millisecond time” not “second time” so simply divide what you have by 1000 in the Excel cell. Then look at the rest of the formulae below for date and time.
1484525700000 1484525700 16/01/2017 900 0 15 0
=B3/1000 =(C3/86400)+25569 =MOD(C3+(25569*86400),86400) =INT(E3/3600) =INT(E3/60) =MOD(E3,60)
this column is formatted as date