15,030
edits
Convert between date and unix timestamp: Difference between revisions
Jump to navigation
Jump to search
→Convert between date and unix timestamp
| Line 75: | Line 75: | ||
* [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?] | ||
* [https://docs.google.com/spreadsheets/d/1mUPLWLdCHcN5Nr3CL2JWYfdYmy4JyiYClXD1kHMLZc4/edit?usp=sharing demo] | * [https://docs.google.com/spreadsheets/d/1mUPLWLdCHcN5Nr3CL2JWYfdYmy4JyiYClXD1kHMLZc4/edit?usp=sharing demo] | ||
=== Excel way: convert to unix timestamp from date === | |||
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> | |||
== References == | == References == | ||