15,030
edits
Convert between date and unix timestamp: Difference between revisions
Jump to navigation
Jump to search
Convert between date and unix timestamp (edit)
Revision as of 15:56, 7 September 2019
, 7 September 2019→Excel way: convert to date from unix timestamp
| Line 75: | Line 75: | ||
* [https://errerrors.blogspot.com/2019/09/how-to-convert-between-date-and-unix-timestamp-in-excel.html 怎樣轉換 Excel 日期時間成 Unix 時間戳記 (unix timestamp)] | * [https://errerrors.blogspot.com/2019/09/how-to-convert-between-date-and-unix-timestamp-in-excel.html 怎樣轉換 Excel 日期時間成 Unix 時間戳記 (unix timestamp)] | ||
* [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?] | ||
<pre> | |||
= (VALUE( date_time )-25569)*86400 | |||
</pre> | |||
=== Excel way: convert to unix timestamp from date === | === Excel way: convert to unix timestamp from date === | ||