Trying to get a 16 digit timestamp converted to excel date/time:
Sample timestamp is as follows:
1296308149533530
Thank you for any advice.
Trying to get a 16 digit timestamp converted to excel date/time:
Sample timestamp is as follows:
1296308149533530
Thank you for any advice.
What are you expecting it to be?
mm/dd/yyyy hh:mm:ss is what I'm hoping for.
Your solution has 14 digits. What would the example you presented end up being
1296308149533530
IF we're looking in order, then 12 is the month and 96 is the day!
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
For that particular stamp the date should be 2-1-2021
What I'm trying to get at here is..
How does 1296308149533530 convert to 2-1-2021 (and what happened to hh:mm:ss)?
You've got to give us some "meaning" to that time stamp. It does not seem to be a UTC or TAI time (usually some kind of "seconds/milliseconds/similar" since 1/1/1970). Feb 1 2021 would be something on the order of 1.612E9 seconds since 1/1/1970.
A 15 or so digit integer, I would guess, would be micro/nano seconds since some reference date/time. As a wild guess, I note that that many microseconds since Jan 1 1980 is jan 28 2021. Beyond that, I haven't got much to offer.
Originally Posted by shg
Besides answering the questions posed in the last two messages above, please tell us if your expected date of 2-1-2021 is February 1st or January 2nd.
With
1296308149533530
with
2-January-2021 = 44198
or
1-Feb-2021 = 44228
could not find any clue that helps
Quang PT
I played with this a little bit but hard to do with a single data point. Since clfletcher is from USA, I assume we are talking about Feb 1, 2021.
To get the number into "Date" range, assuming a simple conversion, it has be be in microseconds
=INT(1206308119533530/(24*60*60*1,000,000)) gives 13961 or 22 Mar 1938.
To normalize that to Feb 1, 2021, one would have to add 30267 (or 12 Nov 1982)
Doesn't really make sense unless that's based on some software start date. Again, a second data point would help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks