This is a simple spreadsheet template to manage the attendance of security guards. It is very simple and if one wants to automate then he/she can insert formulas and edit it according to his business.

guard attendance spreadsheet

View and download

Generally overtime is paid as per business rules or contract. Shift starting time ,hours and holidays etc should be taken care of.
A 30 minute briefing time should be included.Tracking the attendance of employees of security guard agencies is a difficult task, since knowing their exact
place at all times is not easy.