R
RaptorRed
Howdy all,
Question. Is it possible to, since what I want Excel to do has gone way
beyond my skill to program
To me, for what I want sounds more like a marco?
Right now we have two separate excel files, one is scheduling, the other is
the break scheduling.
Right at this moment I have combine them both into one excel file (2
worksheets), is there a way to make excel automatically calculate the breaks
every 2 hrs, no overlapping, (15 mins breaks or 30 min lunch, etc.) But the
rule can be bent a little making some employee's have their breaks from 1 hr
30mins into their breaks or 2hrs 30mins into their shifts
Excel has to list all employee's working that day on one sheet, as well has
to list the time they started to when their shift ends
So far I think I got some of the calculation in... but I think its wrong,
Since it has to be a scenario;
if bob works on Monday from 1pm till 9:30pm breaks listed will be at 3:00,
5:30, 7:30.
However is bob is not working on Monday skip to the next employee.
if Sara works on Monday from 1pm till 9:30pm breaks listed will be at 3:15,
6:00, 7:45
However is Sara is not working on Monday skip to the next employee.
That's one problem.
For the second thing that I am trying to do is to get excel to automatically
calculate hours for everyone in there separate groups. Supervisor's,
Cashiers, attendants.
-However we are on a seniority template system, so who ever has more
seniority gets the hours, example all allocated hours will be used to fill
templates A or B's first, any left over hours will be allocated to C's.
Supervisor's
3 Full time 40 hrs,
Cashiers
2 Full Time 40 hrs (A template)
2 part time 24-32 hrs (B Template)
Attendants.
4 Full Time 40 hrs (A Template)
5 Part Time 24-32 hrs (B Template)
11 Casual 0-23 (C Template)
-Add a line for the work week since during holiday weeks it can be ranging
from 0 hrs, to 40hrs.
-Add a line for RTOs (Requested Time Off) or Vacation for employee's
-Add a line for No OT (Overtime) or TMD (Too Many Days) for the calculation.
-Add a line for allowable hours to allocate to all three positions.
-Add a line where a employee can only work so many hours during a week
-Add a line where a employee cannot work during certain time or days during
a week
-Add a line where a employee gets certain weekends off if he/she has worked
more then 2.
Thanks so much for any answers and help
-Fez
Question. Is it possible to, since what I want Excel to do has gone way
beyond my skill to program
To me, for what I want sounds more like a marco?
Right now we have two separate excel files, one is scheduling, the other is
the break scheduling.
Right at this moment I have combine them both into one excel file (2
worksheets), is there a way to make excel automatically calculate the breaks
every 2 hrs, no overlapping, (15 mins breaks or 30 min lunch, etc.) But the
rule can be bent a little making some employee's have their breaks from 1 hr
30mins into their breaks or 2hrs 30mins into their shifts
Excel has to list all employee's working that day on one sheet, as well has
to list the time they started to when their shift ends
So far I think I got some of the calculation in... but I think its wrong,
Since it has to be a scenario;
if bob works on Monday from 1pm till 9:30pm breaks listed will be at 3:00,
5:30, 7:30.
However is bob is not working on Monday skip to the next employee.
if Sara works on Monday from 1pm till 9:30pm breaks listed will be at 3:15,
6:00, 7:45
However is Sara is not working on Monday skip to the next employee.
That's one problem.
For the second thing that I am trying to do is to get excel to automatically
calculate hours for everyone in there separate groups. Supervisor's,
Cashiers, attendants.
-However we are on a seniority template system, so who ever has more
seniority gets the hours, example all allocated hours will be used to fill
templates A or B's first, any left over hours will be allocated to C's.
Supervisor's
3 Full time 40 hrs,
Cashiers
2 Full Time 40 hrs (A template)
2 part time 24-32 hrs (B Template)
Attendants.
4 Full Time 40 hrs (A Template)
5 Part Time 24-32 hrs (B Template)
11 Casual 0-23 (C Template)
-Add a line for the work week since during holiday weeks it can be ranging
from 0 hrs, to 40hrs.
-Add a line for RTOs (Requested Time Off) or Vacation for employee's
-Add a line for No OT (Overtime) or TMD (Too Many Days) for the calculation.
-Add a line for allowable hours to allocate to all three positions.
-Add a line where a employee can only work so many hours during a week
-Add a line where a employee cannot work during certain time or days during
a week
-Add a line where a employee gets certain weekends off if he/she has worked
more then 2.
Thanks so much for any answers and help
-Fez