<?phpusePhpOffice\PhpSpreadsheet\Spreadsheet;require__DIR__.'/../../Header.php';$helper->log('Returns the serial number of a particular time.');// Create new PhpSpreadsheet object$spreadsheet=newSpreadsheet();$worksheet=$spreadsheet->getActiveSheet();// Add some data$testDates=[[3,15],[13,15],[15,15,15],[3,15,30],[15,15,15],[5],[9,15,0],[9,15,-1],[13,-14,-15],[0,0,-1],];$testDateCount=count($testDates);$worksheet->fromArray($testDates,null,'A1',true);for($row=1;$row<=$testDateCount;++$row){$worksheet->setCellValue('D'.$row,'=TIME(A'.$row.',B'.$row.',C'.$row.')');$worksheet->setCellValue('E'.$row,'=D'.$row);}$worksheet->getStyle('E1:E'.$testDateCount)->getNumberFormat()->setFormatCode('hh:mm:ss');// Test the formulaefor($row=1;$row<=$testDateCount;++$row){$helper->log('Hour: '.$worksheet->getCell('A'.$row)->getFormattedValue());$helper->log('Minute: '.$worksheet->getCell('B'.$row)->getFormattedValue());$helper->log('Second: '.$worksheet->getCell('C'.$row)->getFormattedValue());$helper->log('Formula: '.$worksheet->getCell('D'.$row)->getValue());$helper->log('Excel TimeStamp: '.$worksheet->getCell('D'.$row)->getFormattedValue());$helper->log('Formatted TimeStamp: '.$worksheet->getCell('E'.$row)->getFormattedValue());$helper->log('');}