Hi,
I need your help on the below.
I have timestamp (EST) in DB whihc is in UNIX format. How can we convert the same in to normal date in excel.
1381222222096
1381222507849
1381227500452.
Please let me know if you need any other info.
Thanks in advance.
Prasantha.
Gopavarapu, Good morning.
Please, may you explain better how to determine a real date and time from these line?
Explain and put a real example.
I'm sure that your doubt will receive a solution.
Have a nice day.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
Here is the explanation: http://www.epochconverter.com/
Click on the star if you think I helped you
You can use the following fileUNIX_Time.xlsx
Try this and format as dd/mm/yy hh:mm.
Formula:
Please Login or Register to view this content.
If posting code please use code tags, see here.
Formula:
=(((LEFT(A1,LEN(A1)-3)/60)/60)/24)+DATE(1970,1,1)-"4:00"
Will convert to EST
Format: Custom
m/d/yyyy h:mm:ss AM/PM
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks