Spreadsheet: 204847d1357663590-determine-length-of-breaks-between-shifts-breaks-between-shifts
Sheet: t_Attendance_data

employee_id | allocation_date | type | daily_schedule | period_schedule | status | booking_01 | booking_01_flag | booking_02 | booking_02_flag | booking_03 | booking_03_flag | booking_04 | booking_04_flag | booking_05 | booking_05_flag | booking_06 | booking_06_flag | booking_07 | booking_07_flag | booking_08 | booking_08_flag | Basic | T+1/3 | T+1/2 | Rate 04 | Rate 05 | Rate 06 | Rate 07 | Rate 08 | Rate 09 | Rate 10 | Rate 11 | Rate 12 | Rate 13 | Rate 14 | Rate 15 | Rate 16 | Rate 17 | Rate 18 | Rate 19 | Rate 20
8 | 2012-04-30 00:00:00 | Daily | 08:00 - 16:00 |  |  | 2012-04-30 07:53:00 |  | 2012-04-30 07:53:00 |  | 2012-04-30 16:41:00 |  | 2012-04-30 16:41:00 |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 05:00:00 | 02:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
8 | 2012-05-01 00:00:00 | Daily | 08:00 - 16:00 |  |  | 2012-05-01 07:46:00 |  | 2012-05-01 07:46:00 |  | 2012-05-01 16:42:00 |  | 2012-05-01 16:42:00 |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 05:00:00 | 02:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
8 | 2012-05-02 00:00:00 | Daily | 08:00 - 16:00 |  |  | 2012-05-02 07:38:00 |  | 2012-05-02 07:38:00 |  | 2012-05-02 16:39:00 |  | 2012-05-02 16:39:00 |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 05:00:00 | 02:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
8 | 2012-05-03 00:00:00 | Daily | 08:00 - 16:00 |  |  | 2012-05-03 07:40:00 |  | 2012-05-03 07:40:00 |  | 2012-05-03 16:36:00 |  | 2012-05-03 16:36:00 |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 05:00:00 | 02:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
8 | 2012-05-04 00:00:00 | Daily | 08:00 - 16:00 |  |  | 2012-05-04 07:12:00 |  | 2012-05-04 07:12:00 |  | 2012-05-04 16:01:00 |  | 2012-05-04 16:01:00 |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 05:00:00 | 02:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
8 | 2012-05-05 00:00:00 | Daily | sat & sun |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
8 | 2012-05-06 00:00:00 | Daily | sat & sun |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00