In my PHPExcel I am showing time field and it is showing perfectly. My issue is
At the time of display, it seems ok. But if I double click on the field, then the time 12:00
shows like 1021260:00:00
How can I solve this? The time conversion code is given below
$date = '2016-07-01 12:00:00';
$this -> excel -> getActiveSheet() -> setCellValue('G1', PHPExcel_Shared_Date::PHPToExcel(strtotime($date)));
$this -> excel -> getActiveSheet() -> getStyle('G1') -> getNumberFormat() -> setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3);
At the generation time
After double click
Its using a epoch timestamp chech this page to convert: http://www.epochconverter.com/ Maby this helps you.
Kind regards