Spreadsheet: 765437d1643315473-determining-work-time-based-on-criteria-splitshiftef-dexter2-
Sheet: Data (4)

 | Span | Report | Start | 1st End | G4 | Break | Report | Start | 11th hr | End | b/f 11 1/2 hr | G11 | Job | RT | Comm. | Work Time | STR | G18 | OVER | G19 |  |  |  | Correct Values
 |  |  | 04:30:00 | 08:39:00 |  |  | 12:12:00 | 12:12:00 |  | 15:39:00 |  |  |  | 0:10:00 |  |  |  |  |  |  |  | 7.75 |  |  |  |  | 1. Overtime is paid after either 8 hour completion of work or after the 11th hour mark, However, see #2
 |  |  | 04:35:00 | 11:19:00 |  |  | 14:30:00 | 14:40:00 |  | 15:43:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2. If the job span is greater than 11 1/2 hours and 8 hours of work have not yet been accrued/worked, then overtime is paid after 11 1/2 hours AND the amount of time it takes to reach the 8 hours is also paid at overtime
 |  |  | 04:36:00 | 09:08:00 |  |  | 12:44:00 | 12:54:00 |  | 16:11:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  |  |  |  |  |  | 3. Straight time is either 7.25, 7.5, 7.75, or 8. Overtime is rounded to the quarter hour as well
 |  |  | 04:44:00 | 12:44:00 |  |  | 14:30:00 | 14:40:00 |  | 15:56:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  |  |  |  |  |  | 4. If a break (or SUM of breaks for jobs consisting of working three shifts) is 30 minutes or less, then the break is paid at straight time
 |  |  | 05:05:00 | 06:39:00 |  |  | 11:27:00 | 11:27:00 |  | 16:51:00 |  |  |  | 0:10:00 |  |  |  |  |  |  |  |  |  |  |  |  | 5. The combo commute amount 0:15, is if either Location D is used twice or if it’s a combo of Location D and B or C.
 |  |  | 05:05:00 | 07:55:00 |  |  | 11:27:00 | 11:27:00 |  | 16:51:00 |  |  |  | 0:10:00
 |  |  | 05:08:00 | 08:37:00 |  |  | 11:05:00 | 11:15:00 |  | 15:28:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 8 | 0
 |  |  | 05:20:00 | 10:10:00 |  |  | 12:43:00 | 12:43:00 |  | 17:30:00 |  |  |  | 0:10:00
 |  |  | 05:28:00 | 10:12:00 |  |  | 13:15:00 | 13:25:00 |  | 19:18:00 |  |  |  | 0:20:00
 |  |  | 05:30:00 | 11:27:00 |  |  | 14:20:00 | 14:30:00 |  | 16:03:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 8 | 0
 |  |  | 05:30:00 | 11:27:00 |  |  | 12:35:00 | 12:45:00 |  | 16:03:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 8 | 1.5
 |  |  | 05:35:00 | 11:13:00 |  |  | 14:35:00 | 14:45:00 |  | 17:42:00 |  |  |  | 0:20:00
 |  |  | 05:35:00 | 11:13:00 |  |  | 16:15:00 | 16:25:00 |  | 17:42:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  |  | 1
 |  | 05:45:00 | 05:55:00 | 07:24:00 |  |  | 11:13:00 | 11:13:00 |  | 17:09:00 |  |  |  | 0:10:00 |  |  |  |  |  |  |  | 7.75 | 0.25 |  |  |  | "They also are guaranteed 8 ST hours at 11.5 hours span if that many ST hours have not yet been accrued."
 |  |  | 05:55:00 | 08:10:00 |  |  | 11:13:00 | 11:13:00 |  | 17:09:00 |  |  |  | 0:10:00 |  |  |  |  |  |  |  | 8 | 0.25 |  |  |  | As I understand this, staff are guaranteed 8 ST hours at 11.5 hours span (the last part of the sentence is not necessary).
 |  | 05:50:00 | 06:00:00 | 10:59:00 |  |  | 15:50:00 | 16:00:00 |  | 17:48:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 7.25 | 0.75 |  |  |  | Therefore it seems to me that the STR's in column R that correspond to spans greater than 11 hrs. should be 8.
 |  |  | 06:00:00 | 10:59:00 |  |  | 14:30:00 | 14:40:00 |  | 17:48:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 8 | 0.75
 |  |  | 06:01:00 | 10:19:00 |  |  | 14:00:00 | 14:10:00 |  | 17:32:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 7.5 | 0.5
 |  |  | 06:06:00 | 12:43:00 |  |  | 14:30:00 | 14:40:00 |  | 16:00:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 8 | 0.25
 |  |  | 06:25:00 | 09:24:00 |  |  | 12:30:00 | 12:40:00 |  | 17:21:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 8 | 0
 |  | 08:05:00 | 08:15:00 | 10:05:00 |  |  | 10:31:00 | 10:31:00 |  | 17:11:00 |  |  |  | 0:10:00
 |  |  | 06:15:00 | 08:05:00 |  |  | 10:31:00 | 10:31:00 |  | 17:11:00 |  |  |  | 0:10:00
 |  |  | 06:25:00 | 10:31:00 |  |  | 13:50:00 | 14:00:00 |  | 17:33:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 7.75 | 0.25
 |  |  | 06:27:00 | 11:09:00 |  |  | 14:24:00 | 14:34:00 |  | 18:29:00 |  |  |  | 0:20:00
 |  | 06:20:00 | 06:30:00 | 09:39:00 |  |  | 13:20:00 | 13:30:00 |  | 17:51:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 7.75
 |  |  | 06:30:00 | 11:15:00 |  |  | 13:20:00 | 13:30:00 |  | 17:51:00 |  |  |  | 0:20:00
 |  |  | 06:33:00 | 15:09:00 |  |  | 17:11:00 | 17:11:00 |  | 18:39:00 |  |  |  | 0:10:00
 |  |  | 06:51:00 | 09:55:00 |  |  | 10:20:00 | 10:30:00 |  | 18:19:00 |  |  |  | 0:20:00
 |  |  | 06:51:00 | 08:15:00 |  |  | 10:20:00 | 10:30:00 |  | 18:19:00 |  |  |  | 0:20:00
 |  |  | 06:55:00 | 10:59:00 |  |  | 16:20:00 | 16:30:00 |  | 19:29:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  |  | 1.5
 |  |  | 06:55:00 | 10:59:00 |  |  | 14:38:00 | 14:48:00 |  | 19:29:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 7.5 | 1.5
 |  |  | 07:03:00 | 08:53:00 |  |  | 10:40:00 | 10:50:00 |  | 18:46:00 |  |  |  | 0:20:00
 |  |  | 07:21:00 | 11:25:00 |  |  | 14:45:00 | 14:55:00 |  | 18:59:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 7.75 | 0.75
 |  |  | 09:24:00 | 10:10:00 |  |  | 11:00:00 | 11:10:00 |  | 21:26:00 |  |  |  | 0:20:00
 |  |  | 07:24:00 | 08:10:00 |  |  | 11:00:00 | 11:10:00 |  | 21:26:00 |  |  |  | 0:20:00
 |  |  | 07:25:00 | 12:12:00 |  |  | 14:30:00 | 14:40:00 |  | 18:59:00 |  |  |  | 0:20:00
 |  |  | 07:25:00 | 12:12:00 |  |  | 15:45:00 | 15:55:00 |  | 18:59:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 7.75 | 0.5
 |  |  | 07:55:00 | 10:58:00 |  |  | 14:13:00 | 14:23:00 |  | 19:35:00 |  |  |  | 0:10:00 |  |  |  |  |  |  |  | 7.75 | 0.75
 |  |  | 09:25:00 | 11:45:00 |  |  | 14:50:00 | 15:00:00 |  | 20:01:00 |  |  |  | 0:20:00 |  |  |  |  |  |  |  | 8 | 0
 |  |  | 11:05:00 | 14:23:00 |  |  | 15:20:00 | 15:30:00 |  | 21:18:00 |  |  |  | 0:20:00