Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ABBI
 
Posts: n/a
Default rota for reception cover

I need to devise an on-going 'cover' rota for 1 hour each day, split into 2
half hours, covering weekdays only, with 4 people performing the 'cover' - 2
people = 2x ½ hour per day.

I have dates down the vertical axis and names along the horizontal axis. I
need to show the number of 'covers' per person per week and a running total
of the number of covers. Any one of the 4 people may decide to take a
holiday at any time so the chart needs to show where some have done less and
some have done more.

Has anybody any ideas?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate weeks cover \Kevin Carroll via OfficeKB.com\ Excel Worksheet Functions 2 July 8th 05 01:00 AM
charts hided with black cover res2001 Charts and Charting in Excel 1 July 6th 05 07:27 PM
TRUCK DRIVER COVER LETTER marylynn Excel Discussion (Misc queries) 1 April 5th 05 09:20 PM
head count on rota nick Excel Worksheet Functions 1 March 9th 05 07:39 PM
rota question - very tricky... Michelle Tucker Excel Discussion (Misc queries) 0 November 27th 04 11:55 AM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"