Convert between date and unix timestamp: Difference between revisions

Jump to navigation Jump to search
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 ===

Navigation menu