LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Help making a schedule in Excel...

I am designing a schedule for about 20 employees which includes a first and
second shift. The hours are not identical. For example, some work 6am-4pm,
9am-7pm, 9am-5pm, 2pm-12midnight, 4pm-12midnight, etc.

I am wondering if it is possible to have an automatic calculation for each
day how many staff are scheduled for first shift, and how many are scheduled
for second shift. Of course, I would have to define each shift and whether
it classifies as first or second. How do I do this?

Thank you so much for your help!
 
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
Excel spreadsheet for schedule A Excel Discussion (Misc queries) 2 June 10th 08 06:07 AM
need help making an amortization schedule ~Mike Hollywood Excel Discussion (Misc queries) 4 September 18th 07 04:29 AM
making a schedule from primavera... cocoyman via OfficeKB.com Excel Discussion (Misc queries) 1 December 13th 06 11:31 PM
Create patient schedule based on master therapist schedule PapaBear Excel Discussion (Misc queries) 8 October 12th 05 04:56 AM
making an employee schedule in two sheets dankeith Excel Worksheet Functions 1 December 16th 04 04:10 AM


All times are GMT +1. The time now is 09:39 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"