====== 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 From: http://www.epochconverter.com/