LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
DB DB is offline
external usenet poster
 
Posts: 45
Default Excel Staff Hours Worksheet...

I've created an excel worksheet that I use to hand out duties at work to our
20 staff.......I have most things on it such as start times, finish times,
breaks,lunches etc....

I'm trying to balance things up over the breaks and lunches but it's getting
complicated... I want to try and get an even distibution of staff over all
breaks....

My work sheets have all breaks but I am hoping that there might be an easy
solution to what I want...I have everyones breaks listed.....for
example.....
column F shows morning
breaks....F1...9:30....F2....9:45......F3....10:45 ....F4...11:15.........

Is there a way of showing on a row.......how many people are on a
break........i.e. .if 3 people are on a break at the same time......


If it helps..I can send my excel sheet.............

All help appreciated..

Cheers

Dave :)



 
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
HELP! NEED TEMPLATE FOR ORDERING UNIFORMS FOR STAFF IN EXCEL CHERRYCOKE27 Excel Discussion (Misc queries) 1 April 5th 06 05:28 PM
Staff availability worksheet John N Excel Discussion (Misc queries) 3 February 22nd 06 10:36 AM
how many staff have 1 skill, how many staff have 2 skills, etc. ch90 Excel Discussion (Misc queries) 3 October 27th 05 03:52 PM
Is excel compatible with ANSOS one staff program ? ferde Excel Discussion (Misc queries) 0 October 17th 05 05:25 PM
staff schedule in excel Lonny Excel Discussion (Misc queries) 1 May 15th 05 05:15 AM


All times are GMT +1. The time now is 05:05 AM.

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

About Us

"It's about Microsoft Excel"