You are reading a single comment by @moocher and its replies.
Click here to read the full conversation.
-
It's a unix time stamp.
https://www.unixtimestamp.com/ -
If it's a Unix timestamp it looks a bit screwed up. I'd have thought it should maybe be
1565607390.550 (stamp in milliseconds so divide by 1,000) but that returns 12/08/2019 10:56:31 so not quite right.The Excel formula is normally
=A1/86400+25569with A1 being your timestamp
Colonel_of_Truth
aggi
@moocher
i have a system which displays 2 August 2019 14:36:57 but stores the underlying value as 1565607390550. Is this 13 character string/number proprietory or is there a standard way (ideally in excel) to convert? I want to go from the string to the date/time.