Spreadsheet: 130862d1322628813-how-to-retrieve-the-nth-occurrence-staffbreaks
Sheet: Sheet1

 | MON |  |  |  |  |  |  |  |  |  |  | Time | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00
TEAM | AGENT | Shift start | Break 1 start | Break 1 end | Break 2 start | Break 2 end | Break 3 start | Break 3 end | Break 4 start | Break 4 end | Shift end |  | 11 | 11 | 13 | 13 | 15 | 15 | 17 | 17 | 19 | 19 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 22 | 22 | 20 | 20 | 18 | 18 | 16 | 16 | 14 | 14
Team 1 | Agent 1 | 08:00:00 | 09:00:00 | 09:15:00 | 10:45:00 | 11:15:00 | 13:15:00 | 13:45:00 | 15:45:00 | 16:07:00 | 18:30:00 |  | o | o | o | o | 15 | o | o | o | o | o | o | 30 | 30 | o | o | o | o | o | o | o | o | 30 | 30 | o | o | o | o | o | o | o | o | 22.5 | 22.5 | o | o | o | o | o | o | o | o | o
Team 1 | Agent 1 | 08:00:00 |  |  |  |  |  |  |  |  | 18:30:00 |  | o | o | o | o | 15 | o | o | o | o | o | o | 30 | 30 | o | o | o | o | o | o | o | o | 302 | 302 | o | o | o | o | o | o | o | o | 152 | 7 | o | o | o | o | o | o | o | o | o
Team 1 | Agent 1 | 08:00:00 |  |  |  |  |  |  |  |  | 18:30:00 |  | o | o | o | o | 15 | o | o | o | o | o | o | 30 | 30 | o | o | o | o | o | o | o | o | 302 | 302 | o | o | o | o | o | o | o | o | 152 | 7 | o | o | o | o | o | o | o | o | o
Staff Name | Start | Break
Staff1 | 2011-11-28 06:42:00 | 30
Staff2 | 2011-11-26 03:48:00 | 22
Staff3 | 2011-11-28 03:29:00 | 30
Staff4 | 2011-11-27 05:43:00 | 22
Staff5 | 2011-11-28 01:00:00 | 15 |  |  | Count of Break | Column Labels
Staff6 | 2011-11-26 02:23:00 | 15 |  |  | Row Labels | 15 | 22 | 30 | Grand Total
Staff7 | 2011-11-28 07:22:00 | 15 |  |  | 26-Nov | 4 | 7 | 17 | 28
Staff8 | 2011-11-28 22:58:00 | 15 |  |  | Staff10 |  | 1 | 1 | 2
Staff9 | 2011-11-26 12:49:00 | 15 |  |  | Staff11 |  |  | 1 | 1
Staff10 | 2011-11-28 01:07:00 | 22 |  |  | Staff12 |  |  | 3 | 3
Staff11 | 2011-11-28 16:26:00 | 22 |  |  | Staff13 | 1 | 1 |  | 2
Staff12 | 2011-11-27 17:12:00 | 22 |  |  | Staff14 |  | 1 | 1 | 2
Staff13 | 2011-11-28 16:51:00 | 22 |  |  | Staff15 |  |  | 2 | 2
Staff14 | 2011-11-26 20:10:00 | 30 |  |  | Staff17 | 1 |  |  | 1
Staff15 | 2011-11-27 21:23:00 | 15 |  |  | Staff18 |  | 1 | 1 | 2
Staff16 | 2011-11-27 07:48:00 | 15 |  |  | Staff2 |  | 1 |  | 1
Staff17 | 2011-11-27 07:57:00 | 22 |  |  | Staff20 |  |  | 1 | 1
Staff18 | 2011-11-27 12:25:00 | 22 |  |  | Staff21 |  | 1 | 1 | 2
Staff19 | 2011-11-27 11:08:00 | 30 |  |  | Staff22 |  |  | 1 | 1
Staff20 | 2011-11-27 06:31:00 | 15 |  |  | Staff4 |  |  | 1 | 1
Staff21 | 2011-11-28 20:11:00 | 22 |  |  | Staff5 |  |  | 2 | 2
Staff22 | 2011-11-26 09:09:00 | 22 |  |  | Staff6 |  | 1 | 1 | 2
Staff1 | 2011-11-28 15:55:00 | 15 |  |  | Staff7 | 1 |  |  | 1
Staff2 | 2011-11-28 13:37:00 | 22 |  |  | Staff8 | 1 |  | 1 | 2
Staff3 | 2011-11-27 08:14:00 | 15 |  |  | 27-Nov | 9 | 13 | 7 | 29
Staff4 | 2011-11-27 18:54:00 | 22 |  |  | Staff1 | 1 | 1 | 1 | 3
Staff5 | 2011-11-28 16:33:00 | 15 |  |  | Staff10 |  |  | 1 | 1
Staff6 | 2011-11-28 00:02:00 | 30 |  |  | Staff11 |  | 1 |  | 1
Staff7 | 2011-11-26 03:03:00 | 22 |  |  | Staff13 | 1 |  | 1 | 2
Staff8 | 2011-11-28 23:20:00 | 30 |  |  | Staff14 | 1 |  |  | 1
Staff9 | 2011-11-27 03:25:00 | 15 |  |  | Staff16 | 1 |  |  | 1
Staff10 | 2011-11-26 21:29:00 | 30 |  |  | Staff17 |  | 1 |  | 1
Staff11 | 2011-11-26 16:29:00 | 22 |  |  | Staff18 | 1 | 1 |  | 2
Staff12 | 2011-11-27 15:29:00 | 30 |  |  | Staff19 | 1 |  |  | 1
Staff13 | 2011-11-27 02:58:00 | 15 |  |  | Staff2 |  |  | 1 | 1
Staff14 | 2011-11-28 20:32:00 | 22 |  |  | Staff20 |  | 1 | 1 | 2
Staff15 | 2011-11-27 16:35:00 | 15 |  |  | Staff21 |  | 1 |  | 1
Staff16 | 2011-11-27 03:53:00 | 15 |  |  | Staff22 |  | 1 |  | 1
Staff17 | 2011-11-27 22:45:00 | 22 |  |  | Staff3 |  | 3 |  | 3
Staff18 | 2011-11-26 14:53:00 | 15 |  |  | Staff5 |  | 1 |  | 1
Staff19 | 2011-11-27 13:29:00 | 22 |  |  | Staff6 | 1 |  | 1 | 2
Staff20 | 2011-11-28 23:33:00 | 22 |  |  | Staff7 | 1 | 1 |  | 2
Staff21 | 2011-11-26 16:48:00 | 15 |  |  | Staff9 | 1 | 1 | 1 | 3
Staff22 | 2011-11-27 06:53:00 | 22 |  |  | 28-Nov | 14 | 8 | 9 | 31
Staff1 | 2011-11-28 02:44:00 | 22 |  |  | Staff1 | 1 |  |  | 1
Staff2 | 2011-11-26 18:24:00 | 22 |  |  | Staff10 |  |  | 1 | 1
Staff3 | 2011-11-27 15:14:00 | 30 |  |  | Staff11 |  | 2 |  | 2
Staff4 | 2011-11-27 04:19:00 | 30 |  |  | Staff12 |  | 1 |  | 1
Staff5 | 2011-11-28 08:54:00 | 15 |  |  | Staff14 |  |  | 1 | 1
Staff6 | 2011-11-26 17:05:00 | 15 |  |  | Staff15 | 1 | 1 |  | 2
Staff7 | 2011-11-26 03:00:00 | 15 |  |  | Staff16 | 3 |  |  | 3
Staff8 | 2011-11-27 00:56:00 | 30 |  |  | Staff17 | 1 |  | 1 | 2
Staff9 | 2011-11-26 00:11:00 | 30 |  |  | Staff19 | 3 |  |  | 3
Staff10 | 2011-11-28 08:14:00 | 22 |  |  | Staff2 | 1 | 1 |  | 2
Staff11 | 2011-11-26 11:05:00 | 30 |  |  | Staff20 | 1 |  |  | 1
Staff12 | 2011-11-26 04:30:00 | 30 |  |  | Staff21 | 1 |  |  | 1
Staff13 | 2011-11-26 15:57:00 | 15 |  |  | Staff22 |  | 1 | 1 | 2
Staff14 | 2011-11-28 22:37:00 | 22 |  |  | Staff3 |  |  | 1 | 1
Staff15 | 2011-11-28 17:47:00 | 22 |  |  | Staff4 | 1 |  | 2 | 3
Staff16 | 2011-11-28 04:22:00 | 22 |  |  | Staff5 |  | 1 |  | 1
Staff17 | 2011-11-27 19:36:00 | 30 |  |  | Staff7 |  |  | 1 | 1
Staff18 | 2011-11-27 01:19:00 | 30 |  |  | Staff8 | 1 |  | 1 | 2
Staff19 | 2011-11-26 01:28:00 | 22 |  |  | Staff9 |  | 1 |  | 1
Staff20 | 2011-11-26 21:29:00 | 30 |  |  | Grand Total | 27 | 28 | 33 | 88
Staff21 | 2011-11-27 12:21:00 | 30
Staff22 | 2011-11-27 18:19:00 | 22
Staff1 | 2011-11-26 02:05:00 | 30
Staff2 | 2011-11-27 00:34:00 | 22
Staff3 | 2011-11-28 02:10:00 | 22
Staff4 | 2011-11-27 06:38:00 | 15
Staff5 | 2011-11-28 15:35:00 | 15
Staff6 | 2011-11-28 12:33:00 | 30
Staff7 | 2011-11-26 00:29:00 | 15
Staff8 | 2011-11-26 11:16:00 | 15
Staff9 | 2011-11-28 19:39:00 | 22
Staff10 | 2011-11-28 22:52:00 | 30
Staff11 | 2011-11-27 03:32:00 | 15
Staff12 | 2011-11-27 05:37:00 | 15
Staff13 | 2011-11-26 22:41:00 | 15
Staff14 | 2011-11-27 05:35:00 | 30
Staff15 | 2011-11-28 22:44:00 | 22
Staff16 | 2011-11-27 03:28:00 | 30
Staff17 | 2011-11-26 06:09:00 | 22
Staff18 | 2011-11-27 10:47:00 | 22
Staff19 | 2011-11-28 17:31:00 | 15
Staff20 | 2011-11-27 16:23:00 | 30
Staff21 | 2011-11-27 17:49:00 | 22
Staff22 | 2011-11-27 09:54:00 | 30