How to import this excel spreadsheet into MYSQL using PHPExcel

Topics: Developer Forum, User Forum
Feb 13, 2015 at 3:44 PM
Edited Feb 13, 2015 at 11:55 PM
I need to import a xlsx file that looks like this but I need the date and the starttime to merge into one and the date and endtime to merge into one save it like that into the mysql table as i have two fields that are starttime and endtime and they are DATETIME fields.
                13/02/2015                14/02/2015
userid    starttime    endtime     starttime    endtime
1           12:00          16:00           15:00       20:00
2                                          15:00       20:00
3           16:00         20:00
Could someone please help with writing a script for this? I've looked online but haven't come accross anything useful and I can't get a grisp on how to use PHPExcel...