Any question answered...

You are reading a single comment by @aggi and its replies. Click here to read the full conversation.

•

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.

•

aggi in reply to @moocher
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+25569
```
with A1 being your timestamp

•

moocher in reply to @aggi

That's much closer though. I've been struggling to convert using that formula.
Shown Date = 13 Aug 12:36
Unix = 1565607390550

Doing the Unix / 1000 / 86400 + 25569 also gives me 12 Aug 10:56

So, just over a day out.

About

@aggi started