ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Work Schedule (https://www.excelbanter.com/excel-worksheet-functions/74535-work-schedule.html)

tkc

Work Schedule
 
Ten people working four, nine hour days per wk (36 hrs) and four, nine hour
days and one, eight hour day (44 hrs) to a total of 80 hr bi weekly. Shifts
start at 8 am and end at 8 pm Mon-Fri/Sat 8-5 and Sunday closed. Need at
least four people covering the 12 hour shifts. Four people working 8-5, one
9-6, one 10-7, one 10-8 and three 11:30-8:30. Would prefer to have 2 people
am and 2 people closing (for safety). Any ideas?

intruder9

Work Schedule
 

What you have here is rather confusing! How many people work there 21?
You say 2 in AM 2 in PM do the shifts overlap, try to be a little more
clearer I am sure you understand it but explanation is very confusing
and what do you want in a schedule something that automatically
schedules the people each week? Do they rotate? Be as clear as posible.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=517647



All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com