Excel timesheet including variable start and finish times for different
employees over a fortnightly period.
Should be capable of charting numerous employees and indicating when they
are on annual leave, on call, rostered on, over-time etc.
Different coloured cells would indicate different duties ie.
ROSTERED ON NORMAL DUTIES
COMPLAINTS NORTH
COMPLAINTS SOUTH/POUND
PARKING
ON CALL

and leave ie.
ROSTERED DAY OFF
ALLOCATED DAY OFF
TIME IN LIEU
PUBLIC SERVICE HOLIDAY
PUBLIC HOLIDAY
APPROVED REC LEAVE
SICK / WORKERS COMP LEAVE
OTHER LEAVE
A legend would be required at top of spreadsheet.

Spreadsheet should automatically calculate hours worked on a daily basis and
at the end of the pay period.
This roster would be appropriate for rangers, police etc. and enable
employees to see who was on duty at a glance.