Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 4th 05, 09:46 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2005
Posts: 12
Default Formula for a Rotating Work Schedule?

Hello. Does anyone know if Excel can be used to automatically create
a rotating work schedule for staff?

We want 3 teams (for 3 shifts), with 7 people on each team. Each
person will work standard hours (5 days on, then 2 days off), but their
days will be staggered so that staff will be here every day.

I have never seen a scheduling worksheet in Excel. Is this possible,
or would another software application be better?

Thanks,
Jessi


  #2   Report Post  
Old April 4th 05, 10:20 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2005
Posts: 12
Default Formula for a Rotating Work Schedule?

An addendum...

Well, I was confused... staff will NOT always work 5 days on, then 2
days off. There could be ANY combination of work days, as long as the

employee does not work more than 40 hours per week, and has off *a*
Saturday and *a* Sunday at least every 3 weeks.

Could Excel be used to automatically create a work schedule for a group

of employees?

Thanks,
Jessi

  #3   Report Post  
Old April 5th 05, 01:16 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default Formula for a Rotating Work Schedule?

Obviously, you are not the first to have to deal with a shift schedule - so
There are all kinds of scheduling applications around (some may even be
free). You might try to google to find some. I doubt a formula would be
useful in this situation and setting up a spread sheet to do it would
probably take a lot of work and not be very robust to boot.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
An addendum...

Well, I was confused... staff will NOT always work 5 days on, then 2
days off. There could be ANY combination of work days, as long as the

employee does not work more than 40 hours per week, and has off *a*
Saturday and *a* Sunday at least every 3 weeks.

Could Excel be used to automatically create a work schedule for a group

of employees?

Thanks,
Jessi





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
3 hour rotating schedule icutey2 Excel Discussion (Misc queries) 0 April 25th 10 05:15 AM
Creating a weekly rotating employee work schedule deana06262 Excel Discussion (Misc queries) 0 November 12th 07 05:29 PM
Creating a Rotating Schedule lohende Excel Discussion (Misc queries) 0 July 24th 07 09:56 PM
Creating a rotating schedule Michael Slater New Users to Excel 5 July 24th 07 05:48 AM
create work schedule in Excell (6employees rotating shifts) suzyg23 Excel Worksheet Functions 1 December 9th 06 07:21 PM


All times are GMT +1. The time now is 02:03 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017