Hi I have just started with PHPExcel and am trying to read a time value from an xlsx but the data I'm extracted isn't correct. In Excel I have set the cell format as "1:30:00 PM" from the Time tab of the Format Cells option and entered a
date of 8:30:00 AM. I'm using the following code to extract the cell data -
$start = ($objPHPExcel->getActiveSheet()->getCell('D7'));
echo 'start '.$start->getValue();
What actually gets echo'd to the screen is -
Do I have to perform a formatting operation on this return value? Or is how I'm extracting the data wrong? I greatly appreciate any help that can be given.