User Tools

Site Tools


software:excel

Differences

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

Link to this comparison view

Next revision
Previous revision
software:excel [2014/03/20 22:25] – created superwizardsoftware:excel [2014/03/20 22:34] (current) superwizard
Line 3: Line 3:
 From: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/how-i-convert-epoch-time-to-normal-time-and-show/109d5be6-0ed6-44db-9799-2143e447ba18 From: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/how-i-convert-epoch-time-to-normal-time-and-show/109d5be6-0ed6-44db-9799-2143e447ba18
  
-    The correct succinct formula is =(J2-6*3600)/86400+25569+    The correct succinct formula is =(J2-5*3600)/86400+25569  
 +    The -5*3600 is for my time zone 
 +     
 +From: http://www.epochconverter.com/
software/excel.1395354321.txt.gz · Last modified: 2014/03/20 22:25 (external edit)