Spreadsheet: 756820d1637813114-help-please-on-time-sheet-current-time-sheet-19022021
Sheet: Main Sheet

 | Shifts | Normal | 15% (PM shift) | DOC | Public Hol | Saturday | Sunday | VOT
 | [NAME] | 30.2526 | 4.5379
 | Day of Week | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | Shift |  |  |  | B407 | B403 | B401 | B707 | D819 | B419 | B413 | B405 | B403 | 8B403
 |  | 2021-10-31 00:00:00 | 2021-11-01 00:00:00 | 2021-11-02 00:00:00 | 2021-11-03 00:00:00 | 2021-11-04 00:00:00 | 2021-11-05 00:00:00 | 2021-11-06 00:00:00 | 2021-11-07 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-11 00:00:00 | 2021-11-12 00:00:00 | 2021-11-13 00:00:00
 | Time In | DAY OFF | DAY OFF | DAY OFF | 16:14:00 | 16:04:00 | 16:04:00 | 15:03:00 | 13:18:00 | 13:14:00 | 15:54:00 | 15:44:00 | 16:04:00 | 15:48:00 | DAY OFF
 | Time out |  |  |  | 21:05:00 | 21:03:00 | 21:00:00 | 20:03:00 | 17:56:00 | 17:40:00 | 20:22:00 | 20:18:00 | 21:03:00 | 20:06:00
 | First Shift Hours
 | Time In |  |  |  | 21:55:00 | 21:53:00 | 21:50:00 | 20:53:00 | 18:46:00 | 18:30:00 | 21:10:00 | 21:08:00 | 21:53:00 | 20:56:00
 | Time out |  |  |  | 01:27:00 | 01:42:00 | 01:27:00 | 1900-01-01 00:15:00 | 21:22:00 | 22:06:00 | 1900-01-01 00:52:00 | 01:27:00 | 01:42:00 | 01:27:00
 | Second shift Hours
 | Total Hrs Worked
 | Decimal Hours
 | Spread |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
 | Penalty Rate 15%
 | Hours Paid
 | B [NAME].
 | Shifts | Normal | 15% (PM shift) | DOC | Public Hol | Saturday | Sunday | VOT
 | [NAME] | 30.2526 | 4.5379
 | Day of Week | SUN | MON | TUE/DOC | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | SHIFT |  | B417 | D009 | B411 | B415 | 8B417 | B711 | D811 | B417 | B419 | B409 | B409 |  | B711
 |  | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 2021-10-16 00:00:00 | 2021-10-17 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 2021-10-22 00:00:00 | 2021-10-23 00:00:00 | 2021-10-24 00:00:00 | 2021-10-25 00:00:00 | 2021-10-26 00:00:00 | 2021-10-27 00:00:00
 | Time In | DAY OFF | 14:57:00 | 14:49:00 | 15:31:00 | 15:05:00 | 13:18:00 | 12:52:00 | 14:59:00 | 14:57:00 | 13:14:00 | 13:18:00 | 15:41:00 | DAY OFF | 12:52:00
 | Time out |  | 19:52:00 | 19:41:00 | 19:44:00 | 19:30:00 | 17:52:00 | 16:31:00 | 19:17:00 | 19:52:00 | 17:40:00 | 17:52:00 | 17:52:00 |  | 16:31:00
 | First Shift Hours
 | Time In |  | 20:47:00 | 20:31:00 | 20:34:00 | 20:18:00 | 18:42:00 | 17:21:00 | 20:07:00 | 20:47:00 | 18:30:00 | 18:42:00 | 18:42:00 |  | 17:21:00
 | Time out |  | 1900-01-01 00:27:00 | 1900-01-01 00:23:00 | 1900-01-01 00:55:00 | 00:35:00 | 22:35:00 | 22:06:00 | 1900-01-01 00:35:00 | 1900-01-01 00:27:00 | 22:06:00 | 22:35:00 | 22:35:00 |  | 22:06:00
 | Second shift Hours
 | Total Hrs Worked
 | Decimal Hours
 | Spread |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Penalty Rate 15%
 | Hours Paid
 | B [NAME].
 | Day of Week | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | SHIFT |  | B417 | D009 | B411 | B415 | 8B417 | B711 | D811 | B417 | B419 | B409 | B409 |  | B711
 |  | 2021-11-28 00:00:00 | 2021-11-29 00:00:00 | 2021-11-30 00:00:00 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00 | 2021-12-03 00:00:00 | 2021-12-04 00:00:00 | 2021-12-05 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00 | 2021-12-09 00:00:00 | 2021-12-10 00:00:00 | 2021-12-11 00:00:00
 | Time In | DAY OFF | 14:57:00 | 14:49:00 | 15:31:00 | 15:05:00 | 13:18:00 | 12:52:00 | 14:59:00 | 14:57:00 | 13:14:00 | 13:18:00 | 13:18:00 | DAY OFF | 12:52:00
 | Time out |  | 19:52:00 | 19:41:00 | 19:44:00 | 19:30:00 | 17:52:00 | 16:31:00 | 19:17:00 | 19:52:00 | 17:40:00 | 17:52:00 | 17:52:00 |  | 16:31:00
 | First Shift Hours
 | Time In |  | 20:47:00 | 20:31:00 | 20:34:00 | 20:18:00 | 18:42:00 | 17:21:00 | 20:07:00 | 20:47:00 | 18:30:00 | 18:42:00 | 18:42:00 |  | 17:21:00
 | Time out |  | 1900-01-01 00:27:00 | 1900-01-01 00:23:00 | 1900-01-01 00:55:00 | 00:35:00 | 22:35:00 | 22:06:00 | 1900-01-01 00:35:00 | 1900-01-01 00:27:00 | 22:06:00 | 22:35:00 | 22:35:00 |  | 22:06:00
 | Second shift Hours
 | Total Hrs Worked
 | Decimal Hours
 | Spread |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Penalty Rate 15%
 | Hours Paid
 | B [NAME]. |  | 24.9 | 24.9 | 24.9 | 24.9 | 24.9 | 24.9 | 24.9 | 24.9 | 24.9 | 24.9 | 24.9 |  | 24.9
 |  |  | Missed start shift |  |  | DOC
 | Day of Week | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 |  | 2018-07-15 00:00:00 | 2018-07-16 00:00:00 | 2018-07-17 00:00:00 | 2018-07-18 00:00:00 | 2018-07-19 00:00:00 | 2018-07-20 00:00:00 | 2018-07-21 00:00:00 | 2018-07-22 00:00:00 | 2018-07-23 00:00:00 | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | 2018-07-26 00:00:00 | 2018-07-27 00:00:00 | 2018-07-28 00:00:00
 | Time In
 | Time out
 | Time In
 | Time out
 | Hours Worked
 | Spread
 | Travel Time |  | 30.14 | 30.14 | 30.14 | 30.14 | 30.14 |  |  | 30.14 | 30.14 | 30.14 | 30.14 | 30.14 | 30.14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Hours Paid