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.
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.