Spreadsheet: 756194d1637330922-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.5378
 | Day of Week | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 |  |  |  |  | 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
 | Penalty Rate 15% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Hours Paid
 | B [NAME]. |  |  |  | 24.9 | 24.9 | 24.9 | 24.9 |  | 24.9 | 24.9 | 24.9 | 24.9 | 24.9
 | Day of Week | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 |  | 2021-04-04 00:00:00 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 | 2021-04-07 00:00:00 | 2021-04-08 00:00:00 | 2021-04-09 00:00:00 | 2021-04-10 00:00:00 | 2021-04-11 00:00:00 | 2021-04-12 00:00:00 | 2021-04-13 00:00:00 | 2021-04-14 00:00:00 | 2021-04-15 00:00:00 | 2021-04-16 00:00:00 | 2021-04-17 00:00:00
 | Time In |  | 15:16:00 | 15:48:00 | 15:48:00 | 15:05:00 | 13:18:00 | DAY OFF | 14:29:00 | 15:28:00 | 13:18:00 | 13:18:00 | DAY OFF | 15:33:00 | 15:48:00
 | Time out |  | 20:03:00 | 20:06:00 | 20:06:00 | 19:30:00 | 17:52:00 |  | 19:13:00 | 19:18:00 | 17:52:00 | 17:52:00 |  | 20:25:00 | 20:04:00
 | First Shift Hours
 | Time In |  | 20:53:00 | 20:56:00 | 20:56:00 | 20:18:00 | 18:42:00 |  | 20:03:00 | 20:08:00 | 18:42:00 | 18:42:00 |  | 21:16:00 | 20:54:00
 | Time out |  | 00:55:00 | 01:27:00 | 01:27:00 | 00:35:00 | 22:35:00 |  | 21:51:00 | 00:52:00 | 22:35:00 | 22:35:00 |  | 00:23:00 | 00:55:00
 | Second shift Hours
 | Total Hrs Worked
 | Spread
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Hours Paid
 | Day of Week | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 |  | 2019-01-13 00:00:00 | 2019-01-14 00:00:00 | 2019-01-15 00:00:00 | 2019-01-16 00:00:00 | 2019-01-17 00:00:00 | 2019-01-18 00:00:00 | 2019-01-19 00:00:00 | 2019-01-20 00:00:00 | 2019-01-21 00:00:00 | 2019-01-22 00:00:00 | 2019-01-23 00:00:00 | 2019-01-24 00:00:00 | 2019-01-25 00:00:00 | 2019-01-26 00:00:00
 | Time In
 | Time out
 | First Shift Hours
 | Time In
 | Time out
 | Second shift Hours
 | Hours Worked
 | Spread |  |  |  |  | 30.14 | 30.14 | 30.14 |  | 30.14 | 30.14 | 30.14 | 30.14 | 30.14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Hours Paid
 |  |  | 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
 |  | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | Day of Week | 2018-07-29 00:00:00 | 2018-07-30 00:00:00 | 2018-07-31 00:00:00 | 2018-08-01 00:00:00 | 2018-08-02 00:00:00 | 2018-08-03 00:00:00 | 2018-08-04 00:00:00 | 2018-08-05 00:00:00 | 2018-08-06 00:00:00 | 2018-08-07 00:00:00 | 2018-08-08 00:00:00 | 2018-08-09 00:00:00 | 2018-08-10 00:00:00 | 2018-08-11 00:00:00
 |  | Day Off |  |  |  |  |  |  | Day Off
 | Time In
 | Time out
 | Time In
 | Time out
 | Hours Worked
 | Spread |  |  |  |  | 30.14 | 30.14 | 30.14 |  | 30.14 | 30.14 | 30.14 | 30.14 | 30.14 | 30.14
 | Travel Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Hours Paid