Spreadsheet: 95425d1295017211-timekeeping-merge-and-sort-non-adjacent-cells-excel-help-want
Sheet: 01.05.2011

Employee | Event | Log Time | Minutes |  | Tardy?
45204 | Start of Day
 | Break 1 Starts |  |  |  |  | Tardies | 0
 | Break 1 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | [NAME]
 | Lunch Ends |  | 1900-01-01 00:00:00 | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | End of Day
Employee | Event | Log Time | Minutes |  | Tardy?
45085 | Start of Day | 07:27:00
 | Break 1 Starts | 10:02:00 |  |  |  | Tardies | 0
 | Break 1 Ends | 10:17:00 | 00:15:00 | 899.9999999999968 | No
 | [NAME] | 12:15:00
 | Lunch Ends | 13:00:00 | 00:45:00 | 2700 | No
 | Break 2 Starts | 14:04:00
 | Break 2 Ends | 14:19:00 | 00:15:00 | 899.9999999999968 | No
 | End of Day | 16:15:00
Employee | Event | Log Time | Minutes |  | Tardy?
45106 | Start of Day | 07:53:00
 | Break 1 Starts | 10:05:00 |  |  |  | Tardies | 0
 | Break 1 Ends | 10:20:00 | 00:15:00 | 899.9999999999968 | No
 | [NAME] | 12:30:00
 | Lunch Ends | 13:16:00 | 00:45:00 | 2700 | No
 | Break 2 Starts | 14:45:00
 | Break 2 Ends | 15:00:00 | 00:15:00 | 899.9999999999968 | No
 | End of Day | 16:45:00
Employee | Event | Log Time | Minutes |  | Tardy?
45202 | Start of Day | 07:59:00
 | Break 1 Starts | 10:29:00 |  |  |  | Tardies | 0
 | Break 1 Ends | 10:44:00 | 00:15:00 | 899.9999999999968 | No
 | [NAME] | 12:00:00
 | Lunch Ends | 12:46:00 | 00:45:00 | 2700 | No
 | Break 2 Starts | 15:12:00
 | Break 2 Ends | 15:27:00 | 00:15:00 | 899.9999999999968 | No
 | End of Day | 16:45:00
Employee | Event | Log Time | Minutes |  | Tardy?
45152 | Start of Day
 | Break 1 Starts |  |  |  |  | Tardies | 0
 | Break 1 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | [NAME]
 | Lunch Ends |  | 1900-01-01 00:00:00 | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | End of Day
Employee | Event | Log Time | Minutes |  | Tardy?
45153 | Start of Day
 | Break 1 Starts |  |  |  |  | Tardies | 0
 | Break 1 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | [NAME]
 | Lunch Ends |  | 1900-01-01 00:00:00 | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | End of Day
Employee | Event | Log Time | Minutes |  | Tardy?
45037 | Start of Day | 06:57:00
 | Break 1 Starts | 09:51:00 |  |  |  | Tardies | 0
 | Break 1 Ends | 10:03:00 | 00:12:00 | 720.0000000000023 | No
 | [NAME] | 12:35:00
 | Lunch Ends | 13:20:00 | 00:45:00 | 2700 | No
 | Break 2 Starts | 14:46:00
 | Break 2 Ends | 15:01:00 | 00:15:00 | 899.9999999999968 | No
 | End of Day | 15:45:00
Employee | Event | Log Time | Minutes |  | Tardy?
45177 | Start of Day | 07:57:00
 | Break 1 Starts | 10:45:00 |  |  |  | Tardies | 0
 | Break 1 Ends | 10:58:00 | 00:13:00 | 779.9999999999973 | No
 | [NAME]
 | Lunch Ends |  | 1900-01-01 00:00:00 | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | End of Day | 12:00:00
Employee | Event | Log Time | Minutes |  | Tardy?
45074 | Start of Day
 | Break 1 Starts |  |  |  |  | Tardies | 0
 | Break 1 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | [NAME]
 | Lunch Ends |  | 1900-01-01 00:00:00 | 0 | No
 | Break 2 Starts
 | Break 2 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | End of Day
Employee | Event | Log Time | Minutes |  | Tardy?
45024 | Start of Day | 08:06:00
 | Break 1 Starts | 12:09:00 |  |  |  | Tardies | 0
 | Break 1 Ends | 12:20:00 | 00:11:00 | 660.0000000000073 | No
 | [NAME] | 13:14:00
 | Lunch Ends | 13:59:00 | 00:45:00 | 2700 | No
 | Break 2 Starts
 | Break 2 Ends |  | 1900-01-01 00:00:00 | 0 | No
 | End of Day | 17:00:00