Solved

Dates from XML file

Posted on 2011-09-22
4
248 Views
Last Modified: 2012-05-12
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
Comment
Question by:bryanscott53
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 4

Expert Comment

by:sakman
ID: 36581006
In Linux you can use the "date" command:

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

Open in new window

0
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 36581010
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
 
LVL 50

Expert Comment

by:barry houdini
ID: 36581031
Note: my suggestion should give you GMT - you might have to adjust for other time zones and/or DST/BST

regards, barry
0
 

Author Closing Comment

by:bryanscott53
ID: 36581083
perfect thanks!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question