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: 2016/10/18 11:02 by bpienig
 
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