function createDate($numValue)
    {
        if ($numValue > 1) {
            $utcDays = $numValue - ($this->nineteenFour ? SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904 : SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS);
            $utcValue = round(($utcDays+1) * SPREADSHEET_EXCEL_READER_MSINADAY);
            $string = date ($this->curformat, $utcValue);
            $raw = $utcValue;
        } else {
            $raw = $numValue;
            $hours = floor($numValue * 24);
            $mins = floor($numValue * 24 * 60) - $hours * 60;
            $secs = floor($numValue * SPREADSHEET_EXCEL_READER_MSINADAY) - $hours * 60 * 60 - $mins * 60;
            $string = date ($this->curformat, mktime($hours, $mins, $secs));
        }

        return array($string, $raw);
    }
function createDate($numValue)
    {
        if ($numValue > 1) {
            $utcDays = $numValue - ($this->nineteenFour ? SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904 : SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS);
            $utcValue = round(($utcDays+1) * SPREADSHEET_EXCEL_READER_MSINADAY);
            $string = date ($this->curformat, $utcValue);
            $raw = $utcValue;
        } else {
            $raw = $numValue;
            $hours = floor($numValue * 24);
            $mins = floor($numValue * 24 * 60) - $hours * 60;
            $secs = floor($numValue * SPREADSHEET_EXCEL_READER_MSINADAY) - $hours * 60 * 60 - $mins * 60;
            $string = date ($this->curformat, mktime($hours, $mins, $secs));
        }

        return array($string, $raw);
    }
function createDate ( $ numValue ) { if ( $ numValue > 1 ) { $ utcDays = $ numValue - ( $ this -> nineteenFour ? SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904 : SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS ) ; $ utcValue = round ( ( $ utcDays + 1 ) * SPREADSHEET_EXCEL_READER_MSINADAY ) ; $ string = date ( $ this -> curformat , $ utcValue ) ; $ raw = $ utcValue ; } else { $ raw = $ numValue ; $ hours = floor ( $ numValue * 24 ) ; $ mins = floor ( $ numValue * 24 * 60 ) - $ hours * 60 ; $ secs = floor ( $ numValue * SPREADSHEET_EXCEL_READER_MSINADAY ) - $ hours * 60 * 60 - $ mins * 60 ; $ string = date ( $ this -> curformat , mktime ( $ hours , $ mins , $ secs ) ) ; } return array ( $ string , $ raw ) ; }
Convert the raw Excel date into a human readable format

Dates in Excel are stored as number of seconds from an epoch.  On
Windows, the epoch is 30/12/1899 and on Mac it's 01/01/1904

@access private
@param integer The raw Excel value to convert
@return array First element is the converted date, the second element is number a unix timestamp
Convert the raw Excel date into a human readable format