• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

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?
0
bryanscott53
Asked:
bryanscott53
  • 2
1 Solution
 
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:
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
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now