Any question answered...

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

•

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.

•

aggi in reply to @moocher

It's not a weird time zone is it? (Although I can't really see how you'd get such a large difference from time zone.)

Do you have multiple dates? Is the difference always the same?

About

Avatar for moocher @moocher started