• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to turn a 10 digit number into a date/time

B

Berra2k

New Member
Hi All,

I have received several tables of data. One column in each sheet has a "created_on" field in which it has a 10 digit number I have to turn into a date and time.

This:
1401836141
Needs to turn into this:
6/3/2014 22:55

This is for a data analysis test but I need to know how to convert the numbers accordingly.

Any help would be appreciated, I have tried many things but can not seem to get the same date/time from the number.
 
Hi ,

1. You have posted just one example ; from this example , I am not able to understand how you would derive the date and time that you have mentioned.

2. Is the rest of the data following the same format ?

Narayan
 
Yes, I will add all the examples I can. The first sheet the dates were wrong, but a few had the correct format - the second "corrected" sheet has 10 digit numbers.

All the examples I have:
1401836141 6/3/2014 22:55
1399500266 5/7/2014 22:04
1399500496 5/7/2014 22:08
1399510734 5/8/2014 0:58
1399512777 5/8/2014 1:32
 
Hi ,

I have absolutely no idea how to get the dates and times you have posted from the 10-digit numbers ; dates and times in Excel are just numbers , and the dates and times you have posted will translate to the following numbers :

41704.954861111100000
41825.919444444400000
41825.922222222200000
41856.040277777800000
41856.063888888900000

How would we get these numbers from the 10-digit numbers you have posted ?

Narayan
 
I have no idea, again its for a data analysis test but I can't analyze the data without knowing the correct dates...

Maybe I will contact the hiring manager to see if it is another mistake.
 
I suspect that
the first column is data
the second column is dates
the third column are times
I don't think the first column is related to the dates/times at all
 
You must log in or register to reply here.
Back
Top