PHPExcel 导入时间格式的转换

function excelTime($date, $time=false){
if(is_numeric($date)){
   $jd = GregorianToJD(1, 1, 1970);
   $gregorian = JDToGregorian($jd+intval($date)-25569);
   $date = explode('/',$gregorian);
   $date_str = str_pad($date[2],4,'0', STR_PAD_LEFT)
    ."-".str_pad($date[0],2,'0', STR_PAD_LEFT)
    ."-".str_pad($date[1],2,'0', STR_PAD_LEFT)
    .($time?" 00:00:00":'');
   return $date_str;
}
return $date;

}

时分：$d=gmdate('H:i',\PHPExcel_Shared_Date::ExcelToPHP($dd));