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

Similar Threads

Construct staff pay timesheet 1
How do I create a travel expense report by employee, by campus, b. 2
how do I create a duty roster 2
how do i set up a weekly multi-employee timesheet? 2
How to create an if statement to get a multiple result 0
How to Gather TimeSheet Data to Create Invoice 2
How do I link 2 spreadsheets to insert amounts on a defined date? 0
How would I do the following? A little complicated in detail...but I don't think to difficult... 0

Top