Feb 13, 2015 at 2:44 PM
Edited Feb 13, 2015 at 10: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
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...