15,030
edits
Convert between date and unix timestamp: Difference between revisions
Jump to navigation
Jump to search
m
Convert between date and unix timestamp (edit)
Revision as of 14:00, 9 September 2019
, 9 September 2019no edit summary
mNo edit summary |
|||
| Line 76: | Line 76: | ||
* [https://www.extendoffice.com/documents/excel/2473-excel-timestamp-to-date.html How to convert between date and Unix timestamp in Excel?] | * [https://www.extendoffice.com/documents/excel/2473-excel-timestamp-to-date.html How to convert between date and Unix timestamp in Excel?] | ||
timezone: UTC | |||
<pre> | <pre> | ||
= (VALUE( date_time )-25569)*86400 | = (VALUE( date_time )-25569)*86400 | ||
| Line 83: | Line 84: | ||
input data (A2 cell): YYYY/MM/DD (e.g. {{CURRENTYEAR}}/{{CURRENTMONTH}}/{{CURRENTDAY2}} ) or YYYY/MM/DD HH:MM (e.g. {{CURRENTYEAR}}/{{CURRENTMONTH}}/{{CURRENTDAY2}} {{CURRENTTIME}}) {{kbd | key==(A2-DATE(1970,1,1))*86400}} <ref>[http://stackoverflow.com/questions/1703505/excel-date-to-unix-timestamp Excel date to Unix timestamp - Stack Overflow]</ref> | input data (A2 cell): YYYY/MM/DD (e.g. {{CURRENTYEAR}}/{{CURRENTMONTH}}/{{CURRENTDAY2}} ) or YYYY/MM/DD HH:MM (e.g. {{CURRENTYEAR}}/{{CURRENTMONTH}}/{{CURRENTDAY2}} {{CURRENTTIME}}) {{kbd | key==(A2-DATE(1970,1,1))*86400}} <ref>[http://stackoverflow.com/questions/1703505/excel-date-to-unix-timestamp Excel date to Unix timestamp - Stack Overflow]</ref> | ||
timezone: UTC | |||
<pre> | <pre> | ||
= TEXT( (Unixtime / 86400) + 25569, "YYYY-mm-dd hh:mm:ss") | = TEXT( (Unixtime / 86400) + 25569, "YYYY-mm-dd hh:mm:ss") | ||