Computer and IT knowledge - things to know
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