# Problem converting unix time from exported CVS file

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 ?.

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.

Date hour mins secs
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)
mod stuff
this column is formatted as date

2 Likes