list of dates and times sorted to rows by date in excel

list of dates and times sorted to rows by date in excel

I have a spread sheet that looks like this
Emp.    date       time
1       5-13-13    8:00
1       5-13-13    12:00
1       5-13-13    12:30
1       5-13-13    15:00
2       5-13-13    8:00
2       5-13-13    12:00
3       5-13-13    8:00
3       5-13-13    12:00
3       5-13-13    12:30
3       5-13-13    15:00
1       5-14-13    8:00
1       5-14-13    12:00
1       5-14-13    12:30
and I would like to automatically convert it to something like this
Emp.    date       in    lunch1   lunch2    out
1       5-13-13    8:00  12:00    12:30     15:00
2       5-13-13    8:00                     12:00
3       5-13-13    8:00  12:00    12:30     15:00
1       5-14-13    8:00  12:00    12:30     15:00 
is there an easy way to do this?