Excel Scriptlets

Convert Unix Time to Excel Time

  • =CELL/(60*60*24)+“1/1/1970”

Convert Excel Time to Unix Time

  • =(CELL-DATE(1970,1,1))*86400
 
 excel_scriptlet.txt · Last modified: 2018/01/21 00:18 (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