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

Employee | Event | Log Time | Minutes |  | Tardy?
45204 | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | 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 |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | 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?
45106 | Start of Day | 07:52:00 |  |  |  | Tardies | 1
 | Break 1 Starts | 10:01:00
 | Break 1 Ends | 10:17:00 | 00:16:00 | 959.9999999999966 | Yes
 | [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:32:00
Employee | Event | Log Time | Minutes |  | Tardy?
45202 | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | 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?
45152 | Start of Day | 07:56:00 |  |  |  | Tardies | 0
 | Break 1 Starts | 09:46:00
 | Break 1 Ends | 10:01:00 | 00:15:00 | 899.9999999999968 | No
 | [NAME] | 11:33:00
 | Lunch Ends | 12:18:00 | 00:45:00 | 2699.999999999995 | 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 |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | 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 |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | 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?
45177 | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | 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?
45074 | Start of Day |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | 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 |  |  |  |  | Tardies | 0
 | Break 1 Starts
 | 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