How do I create a monthly/fortnightly employee roster/timesheet?

G

Green Fingers

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top