software:excel

This is an old revision of the document!

How I convert EPOCH Time to Normal time and show it in Excel 2007?

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-5*3600)/86400+25569 
  The -5*3600 is for my time zone

software/excel.1395354868.txt.gz · Last modified: 2014/03/20 22:34 by superwizard