Problem with time format

Topics: Developer Forum, User Forum
Jan 17, 2008 at 1:42 AM
I seem to be having a problem with a certain time format. Within my Excel file, the data in the cell appears as 6:30, clicking the cell displays 06:30:00 AM. However, when I parse the file with PHPExcel, the value I get for this cell is 0.27083333333333331. So... can someone please explain how I can receive the proper value?
Coordinator
Jan 17, 2008 at 6:39 AM
Check the PHPExcelSharedDate class, method ExcelToPHP