This must match the Definition as given below.
Definition based on sample Excel file provided (Whitebirk).
Source fields are:
Date
Works Order No
Works Activity - Rogue field
Labour First Name
Labour Surname
Absence Status
Start Time (as Decimal)
Finish Time (as Decimal) - May roll over midnight
Breaks
Standby (D / N)
Plant Registration
Hours on Works Order
Note that the 'Depot' is NOT on the worksheet - this must be on the page tab name.
Additionally, Shift Times entered as numeric values, 10.0, 11.30, 19.45 will be read as equivalent times 10:00, 11:30, 19:45 etc. Either format may be given.
The 'Breaks' column is read as decimal hours (0.5 is read as 30 minutes).
Standby is read as just Yes / No (Yes if the cell is not blank).
Attendance status should match the definitions for Staff Columns in the main Allocation Sheet display panels.