How to Find Security Shifts With Uncovered Hours
The roster shows a guard assigned overnight. Attendance starts 40 minutes after the contracted coverage window begins. Check substitutions and handover records before counting the gap.
What to pull
Use Excel coverage, roster and attendance tabs or export contract schedules, assignments and clock records from workforce software. Keep post, site and full timestamps.
How to check it
Compare required coverage intervals with verified presence at each post. Account for overlapping shifts, substitutions and overnight boundaries. Flag missing clock records separately.
Select the relevant sheets in Jolene.pro and run this check.
Which contracted post hours lack verified coverage? Show time windows, exceptions and source rows.
What to do with the result
Send the supervisor the affected post and interval so they can verify handover or approved replacement coverage.
Confirm attendance evidence and site procedures before concluding a post was unattended.