SP CRM

	#	Client Name	Site Name	Shift Date	Shift Time	Break Time	Total Hours	Status	Action
	1	ABC Corporation	London Head Office	2025-01-08	08:00 – 18:00	60 mins	9.0 hrs	Active	View Edit Delete
	2	Global Tech Ltd	Manchester Data Centre	2025-01-09	19:00 – 07:00	45 mins	11.25 hrs	Pending	View Edit Delete

Import Guidelines:

Headers should be in Row 1 starting from Column A
Data should start from Row 2, Column A onwards
Required Columns: Date, Client, Site, Start, End
Optional Columns: #, Day, Officer, Phone, Lost Time, Hours, Comments
Date formats supported: 01-May-2025, 2025-05-01, 01/05/2025
Time formats supported: 06:00, 18:00, 6:00
Client and Site names must already exist in the database
Officer names are matched against employee records (First Name, Last Name, or Full Name)
Hours will be calculated automatically if not provided
If Officer is assigned:
- SIA licence expiry will be validated
- Overlapping shifts will be checked

Select Excel File