libreoffice - make unix timestamp readable

sample timestamp=1499015644 >> written in cell B2:

to get human readable time use the following:
=B2/86400+25569 and format the cell to data format

>> now you should see the human readable date: 02.07.2017

explanation to formula:
- 86400 is the number of seconds of a day (60s * 60 * 24)
- 25569 is the number of days from 30.12.1899 until 01.01.1970 (unix timestamp)
> 30.12.1899 is somehow the day in in libreoffice

computer2know :: thank you for your visit :: have a nice day :: © 2024