When I write a timestamp ('10:54:45') to a cell, the timestamp is actually stored in excel as '2009/12/22 10:54:45' . Now I have a whole column of these timestamps and our client requires us to do a sum of them.
This is obviously not working, I must be doing something really stupid here, but I can't seem to figure out what.
I use PHPExcel version 1.7.1
The code I use to write the data to the cells is the following
I Initialize the PHPExcel classes with the following code
$objWriter = PHPExcel_IOFactory::createWriter($this->objPHPExcel, 'Excel2007');
Thanks in advance guys!
I really love PHPExcel, you guys are doing a great job!