Here’s how to come up with 978307200 and what this number represents.. the number of seconds in between the years Jan 1st, 1970 and Jan 1st 2001.. which is 31 years + 8 leap year days…so

31 years 365 days 8 leap year days 24 hours in a day 60 minutes in a hour 60 seconds in a minute

((31*365))+8)*24*60*60  = 978307200

So with this info, you can change the unix timestamps into human readable form.

Take your timestamp and add 978307200 to it..

timestamp + 978307200 =

285884884.420929 + 978307200 = 1264192084.42093

Now take 1264192084.42093 and divide this by the # of seconds in a day +25569..

1264192084.42093/86400 + 25569 = 40200.8528289459

Now if you take this 40200.8528289459 and convert this to a date in Excel you will get the timestamp..

40200.8528289459 = Friday, January 22, 2010 20:28:04

In Excel or Libre Office Calc

A2 = unix timestamp

=A2+978307200 = A3

=A3/86400 +25569 = A4

Convert A4 to date …and there you go…