Excel单元格选择显示hh：mm：ss格式的时间值的计数而不是总和

Question

I have used phpspreadsheet package for exporting a report. I have write the column values(time value in hh:mm:ss) using the function setCellValueByColumnAndRow and formatted the cell value using setFormatCode function.

After downloading I have selected some specific cells vertically it shows the count of number of cells selected instead of sum of the cell values in time.

            $sheet->setCellValueByColumnAndRow($cellValues[0], $current_row, $val['username']);
            $sheet->setCellValueByColumnAndRow($cellValues[1], $current_row, $val['date']);
            $sheet->setCellValueByColumnAndRow($cellValues[2], $current_row, $jobTimeTaken);
            $sheet->setCellValueByColumnAndRow($cellValues[3], $current_row, $breakTimeTaken);


$sheet->getStyle('G4')
      ->getNumberFormat()
      ->setFormatCode( \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME4);

$sheet->getStyle('G5')
      ->getNumberFormat()
      ->setFormatCode(                     \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME4);