Convert unix timestamp to Excel

Convert unix timestamp to Excel

To do a straight conversion of a UNIX time stamp to the Excel system, all you need to do is use this formula:

=UnixTime / 86400 + 25569

In this example, UnixTime can be either a named cell containing the integer UNIX time stamp value, or it can be replaced with the actual integer value. Since the UNIX time stamp is stored as seconds, the division by 86400 is necessary to convert to days, which is used by Excel. (86400 is the number of seconds in a day.) You then add 25569, which is the number of days between 1 January 1900 and 1 January 1970. (It is the value returned if you use the =DATE(1970,1,1) function.)

How to send email confirmation after form submission
Connecting to a database
Displaying database results
How to use an array
How to edit and replace data
Number format in PHP
Convert unix timestamp to Excel
Combine padding into one single line using CSS
Displaying year using PHP
404 redirect using htaccess
Highlight textarea on click
Htaccess maintenance redirect
Comment out lines in a htaccess file