Spreadsheet: 95210d1294855874-merge-and-sort-non-adjacent-cells-excel-help-want
Sheet: 01.07.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 | 07:26:00 |  |  |  | Tardies | 1
 | Break 1 Starts | 10:02:00
 | Break 1 Ends | 10:17:00 | 00:15:00 | 899.9999999999968 | No
 | [NAME] | 12:18:00
 | Lunch Ends | 13:04:00 | 00:46:00 | 2760 | Yes
 | Break 2 Starts | 14:30:00
 | Break 2 Ends | 14:45:00 | 00:15:00 | 899.9999999999968 | No
 | End of Day | 16:15:00
Employee | Event | Log Time | Minutes |  | Tardy?
45106 | Start of Day | 07:54:00 |  |  |  | Tardies | 2
 | Break 1 Starts | 10:11:00
 | Break 1 Ends | 10:28:00 | 00:17:00 | 1020.000000000001 | Yes
 | [NAME] | 12:30:00
 | Lunch Ends | 13:16:00 | 00:46:00 | 2760 | Yes
 | 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 | 06:54:00 |  |  |  | Tardies | 0
 | Break 1 Starts | 09:24:00
 | Break 1 Ends | 09:39:00 | 00:15:00 | 900.0000000000016 | 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 | 11:06:00
Employee | Event | Log Time | Minutes |  | Tardy?
45152 | 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?
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 | 06:58:00 |  |  |  | Tardies | 1
 | Break 1 Starts | 10:02:00
 | Break 1 Ends | 10:16:00 | 00:14:00 | 840.0000000000018 | No
 | [NAME] | 12:35:00
 | Lunch Ends | 13:21:00 | 00:46:00 | 2760 | Yes
 | Break 2 Starts | 14:25:00
 | Break 2 Ends | 14:40:00 | 00:15:00 | 899.9999999999968 | No
 | End of Day | 14:44:00
Employee | Event | Log Time | Minutes |  | Tardy?
45177 | Start of Day | 07:57:00 |  |  |  | Tardies | 1
 | Break 1 Starts | 11:06:00
 | Break 1 Ends | 11:21:00 | 00:15:00 | 899.9999999999968 | No
 | [NAME] | 12:22:00
 | Lunch Ends | 13:07:00 | 00:45:00 | 2700 | No
 | Break 2 Starts | 15:42:00
 | Break 2 Ends | 15:58:00 | 00:16:00 | 959.9999999999966 | Yes
 | End of Day | 16:45:00
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 | 08:03:00 |  |  |  | Tardies | 3
 | Break 1 Starts | 11:25:00
 | Break 1 Ends | 11:55:00 | 00:30:00 | 1799.999999999998 | Yes
 | [NAME] | 13:12:00
 | Lunch Ends | 14:01:00 | 00:49:00 | 2939.999999999999 | Yes
 | Break 2 Starts | 16:00:00
 | Break 2 Ends | 16:17:00 | 00:17:00 | 1020.000000000006 | Yes
 | End of Day | 16:46:00