Spreadsheet: 838503d1691071901-calculating-hours-worked-between-6pm-and-6am-schedule-sample
Sheet: Sheet1

Date | Plan | Note | Start | Finish | Total/ Hol/ Lieu | [NAME] | [NAME] | Sun Prem
2022-12-11 00:00:00 |  |  |  |  |  |  |  |  | Period | 44
 |  |  |  |  |  |  |  |  | Holiday Pay
 |  |  |  |  |  |  |  |  | Total [NAME] | 3653.95
 |  |  |  |  |  |  |  |  | Previous Mnth | 3285.49
 |  |  |  |  |  |  |  |  | Last Mnth | 3863.25
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  | Basic | 18.45
 |  |  |  |  |  |  |  |  | O/T 1.5
 |  |  |  |  |  |  |  |  | [NAME] | 1.025
 |  |  |  |  |  |  |  |  | Hol Entitlement | 22
 |  |  |  |  |  |  |  |  | Taken
 |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  |  |  |  | Hours | Total
 |  |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  |  | O/T x 1.5
 |  |  |  |  |  |  |  |  | Total Unsoc
 |  |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  |  | Lieu
 |  |  |  |  |  |  |  |  | Adjustment |  | 0
 |  |  |  |  |  |  |  |  | O/T x 2
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Period
 |  |  |  |  |  |  |  |  | Holiday Pay
 |  |  |  |  |  |  |  |  | Total [NAME]
 |  |  |  |  |  |  |  |  | Previous Mnth
 |  |  |  |  |  |  |  |  | Last Mnth
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  | Basic
 |  |  |  |  |  |  |  |  | O/T 1.5
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Hol Entitlement | 22
 |  |  |  |  |  |  |  |  | Taken
 |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  |  |  |  | Hours | Total
 |  |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  |  | O/T x 1.5
 |  |  |  |  |  |  |  |  | Total Unsoc
 |  |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  |  | Lieu
 |  |  |  |  |  |  |  |  | Adjustment |  | 0
 |  |  |  |  |  |  |  |  | O/T x 2
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Period
 |  |  |  |  |  |  |  |  | Holiday Pay
 |  |  |  |  |  |  |  |  | Total [NAME]
 |  |  |  |  |  |  |  |  | Previous Mnth
 |  |  |  |  |  |  |  |  | Last Mnth
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  | Basic
 |  |  |  |  |  |  |  |  | O/T 1.5
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Hol Entitlement
 |  |  |  |  |  |  |  |  | Taken
 |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  |  |  |  | Hours | Total
 |  |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  |  | O/T x 1.5
 |  |  |  |  |  |  |  |  | Total Unsoc
 |  |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  |  | Lieu
 |  |  |  |  |  |  |  |  | Adjustment |  | 0
 |  |  |  |  |  |  |  |  | O/T x 2
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Period | 4
 |  |  |  |  |  |  |  |  | Holiday Pay
 |  |  |  |  |  |  |  |  | Total [NAME]
 |  |  |  |  |  |  |  |  | Previous Mnth
 |  |  |  |  |  |  |  |  | Last Mnth
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  | Basic
 |  |  |  |  |  |  |  |  | O/T 1.5
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Hol Entitlement
 |  |  |  |  |  |  |  |  | Taken
 |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  |  |  |  | Hours | Total
 |  |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  |  | O/T x 1.5 | 0
 |  |  |  |  |  |  |  |  | Total Unsoc
 |  |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  |  | Lieu
 |  |  |  |  |  |  |  |  | Adjustment
 |  |  |  |  |  |  |  |  | O/T x 2
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Period
 |  |  |  |  |  |  |  |  | Holiday Pay
 |  |  |  |  |  |  |  |  | Total [NAME]
 |  |  |  |  |  |  |  |  | Previous Mnth
 |  |  |  |  |  |  |  |  | Last Mnth
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  | Basic
 |  |  |  |  |  |  |  |  | O/T 1.5
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Hol Entitlement | 22
 |  |  |  |  |  |  |  |  | Taken
 |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  |  |  |  | Hours | Total
 |  |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  |  | O/T x 1.5
 |  |  |  |  |  |  |  |  | Total Unsoc
 |  |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  |  | Lieu
 |  |  |  |  |  |  |  |  | Adjustment
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Period
 |  |  |  |  |  |  |  |  | Holiday Pay
 |  |  |  |  |  |  |  |  | Total [NAME]
 |  |  |  |  |  |  |  |  | Previous Mnth
 |  |  |  |  |  |  |  |  | Last Mnth
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  | Basic
 |  |  |  |  |  |  |  |  | O/T 1.5
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Hol Entitlement
 |  |  |  |  |  |  |  |  | Taken
 |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  |  |  |  | Hours | Total
 |  |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  |  | O/T x 1.5
 |  |  |  |  |  |  |  |  | Total Unsoc
 |  |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  |  | Lieu
 |  |  |  |  |  |  |  |  | Adjustment
 |  |  |  |  |  |  |  |  | Sick | 12
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Period
 |  |  |  |  |  |  |  |  | Holiday Pay
 |  |  |  |  |  |  |  |  | Total [NAME]
 |  |  |  |  |  |  |  |  | Previous Mnth
 |  |  |  |  |  |  |  |  | Last Mnth
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  | Basic
 |  |  |  |  |  |  |  |  | O/T 1.5
 |  |  |  |  |  |  |  |  | [NAME] | 1.12
 |  |  |  |  |  |  |  |  | Hol Entitlement
 |  |  |  |  |  |  |  |  | Taken
 |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  |  |  |  | Hours | Total
 |  |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  |  | O/T x 1.5
 |  |  |  |  |  |  |  |  | Total Unsoc
 |  |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  |  | Lieu
 |  |  |  |  |  |  |  |  | Adjustment
 |  |  |  |  |  |  |  |  | Sick
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Period
 |  |  |  |  |  |  |  |  | Holiday Pay
 |  |  | 19:00:00 | 07:00:00 |  |  |  |  | Total [NAME]
 |  |  | 01:00:00 | 11:00:00 |  |  |  |  | Previous Mnth
 |  |  |  |  |  |  |  |  | Last Mnth
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  | Basic
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Saturday [NAME].
 |  |  |  |  |  |  |  |  | Sunday [NAME].
 |  |  |  |  |  |  |  |  | Hol Entitlement
 |  |  |  |  |  |  |  |  | Taken
 |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  |  |  |  | Hours | Total
 |  |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  |  | O/T x 1.5
 |  |  |  |  |  |  |  |  | Total Unsoc
 |  |  |  |  |  |  |  |  | [NAME].
 |  |  |  |  |  |  |  |  | Sun Prm.
 |  |  |  |  |  |  |  |  | Holiday
 |  |  |  |  |  |  |  |  | Lieu
 |  |  |  |  |  |  |  |  | Adjustment
 |  |  |  |  |  |  |  |  | O/T x 2
 |  |  |  |  |  |  |  |  | Total