This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
excel_scriptlet [2016/10/18 18:00]
excel_scriptlet [2019/07/18 04:36] (current)
Line 4: Line 4:
 ===== Convert Unix Time to Excel Time ===== ===== Convert Unix Time to Excel Time =====
   * =CELL/(60*60*24)+"1/1/1970"   * =CELL/(60*60*24)+"1/1/1970"
 +===== Convert Excel Time to Unix Time =====
 +  * =(CELL-DATE(1970,1,1))*86400
 excel_scriptlet.txt ยท Last modified: 2019/07/18 04:36 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
Recent changes RSS feed Driven by DokuWiki