I have a timekeeping report that runs in this format:
(A)Agent Name -- (B)Date -- (C)Login Time -- (D) Logout Date -- (E)Logout Time
employee A. 1/3/2011 7:53AM 1/3/2011 10:05 AM
employee A 1/3/2011 10:20 AM 1/3/2011 12:30 PM
employee A 1/3/2011 1:16 PM 1/3/2011 2:45 PM
employee A 1/3/2011 3:00 PM 1/3/2011 4:45 PM
employee B 1/3/2011 7:59 AM 1/3/2011 10:29AM
employee B 1/3/2011 10:44 AM 1/3/2011 12:00 PM
employee B 1/3/2011 12:45 PM 1/3/2011 3:12 PM
employee B 1/3/2011 3:27 PM 1/3/2011 4:45 PM

and want it be able to drop it an spreadsheet in this format and have it automatically fill C with the data:
(A)Employee -- (B) Event -- (C)Log Time
Employee A Start of Day 7:53:00 AM
Employee A Break 1 Starts 10:05:00 AM
Employee A Break 1 Ends 10:20:00 AM
Employee A Lunch Starts 12:30:00 PM
Employee A Lunch Ends 1:16:00 PM
Employee A Break 2 Starts 2:45:00 PM
Employee A Break 2 Ends 3:00:00 PM
Employee A End of Day 4:45:00 PM
Employee Event Log TimeEmployee B Start of Day 7:59:00 AM
Employee B Break 1 Starts 10:29:00 AM
Employee B Break 1 Ends 10:44:00 AM
Employee B Lunch Starts 12:00:00 PM
Employee B Lunch Ends 12:46:00 PM
Employee B Break 2 Starts 3:12:00 PM
Employee B Break 2 Ends 3:27:00 PM
Employee B End of Day 4:45:00 PM

Which is basically merging C & E, and sorting in order - C3 E3 C4 E4 C5 E5
I can do a formula to have it recognize the name, but can't think of a good way to get the times into one column. Excel 2003. Any tips greatly appreciated!