staff monthly scheduling problem
From: cutemom2jen (cutemom2jen.1cf692_at_excelforum-nospam.com)
Date: 09/11/04
- Next message: Max: "Re: How to calculate fixed rows in Excel ( Sum of every 7 rows for i.."
- Previous message: Sal_N: "'Help on this error' does not work?"
- Next in thread: Sandy Mann: "Re: staff monthly scheduling problem"
- Reply: Sandy Mann: "Re: staff monthly scheduling problem"
- Reply: Bob Wright: "RE: staff monthly scheduling problem"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 11 Sep 2004 07:54:40 -0500
I have recently been given an added responsibility at work that requires
me to prepare a schedule for a staff of 10, some part time, some full.
I have been racking my brain for a month and trying every trick or
formula I could to develop a monthly calendar with set shifts (5/day)
for unchanging employees that would calculate hours for each employee
by week and by month. I would like to be able to program something for
example:
Gary works Tues-Sat 6:30AM-3:00PM, with a 30 minute lunch. The lunch
period does not need to be shown on the calendar since this would
ideally be a hidden formula only necessary for calculation but not
required to be visible on the staff schedule I post. Janie works
Sunday through Thursday 11AM-7:30PM....... and so on.
Can someone give me some direction pleeease? see example of what want
visually, please note the absence of hour totals.
Attachment filename: september04gh.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=691011
--- Message posted from http://www.ExcelForum.com/
- Next message: Max: "Re: How to calculate fixed rows in Excel ( Sum of every 7 rows for i.."
- Previous message: Sal_N: "'Help on this error' does not work?"
- Next in thread: Sandy Mann: "Re: staff monthly scheduling problem"
- Reply: Sandy Mann: "Re: staff monthly scheduling problem"
- Reply: Bob Wright: "RE: staff monthly scheduling problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
