Dates from XML file

I have a list of dates in an xml file like the ones below

1316396952
1313202403
1313202631
1313203362
1313203408
1313203529
1313332457
1313368030

I do not know how to convert into date/time field, can you help?
bryanscott53Asked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Assuming those are seconds from 1st January 1970 (Unix time) then with data in A2 you can use this formula in B2 to convert

=DATE(1970,1,1)+A2/86400

formatted as dd/mm/yyyy hh:mm:ss

Those give me dates in August/September this year - is that right? See attached

regards, barry
27322204.xls
0
 
sakmanCommented:
In Linux you can use the "date" command:

$ date -d @1316396952
Sun Sep 18 18:49:12 MST 2011

Open in new window

0
 
barry houdiniCommented:
Note: my suggestion should give you GMT - you might have to adjust for other time zones and/or DST/BST

regards, barry
0
 
bryanscott53Author Commented:
perfect thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.