ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   schedules (https://www.excelbanter.com/excel-worksheet-functions/102070-schedules.html)

Brad

schedules
 
i am trying to come up with a eight man rotating schedule without working
long stretches without a day off.

Thx
Brad

VBA Noob

schedules
 

Need to post more info than that

e.g

What's the length of day ??
Whats a long stretch in your view ??
How many on per day ??

What cells

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566331


Gord Dibben

schedules
 
Would this be a 24/7 operation?

8 hour shift?

12 hour shift?

How many hours a week per person?

What is the averaging period? 28 days? 8 weeks?

Have a look at this site to get an idea of how to work with some of the above
and other parameters.

http://www.shift-work.com/shift-schedules/

See some sample schedules when you scroll down to bottom of page.


Gord Dibben MS Excel MVP

On Sat, 29 Jul 2006 14:15:02 -0700, Brad wrote:

i am trying to come up with a eight man rotating schedule without working
long stretches without a day off.

Thx
Brad




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

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