mitchleeey
New member
- Joined
- Dec 28, 2018
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
Hi all,
New to the forum. I need a bit of help.
I’m in charge of rostering where I work and I’m looking for a way to calculate a percentage of shifts worked by x amount of staff.
For example....
We have 5 shifts to cover throughout the day. 3 morning, 2 night. The the roster is monthly, every few days the staff change from days to nights and vise versa. How do I calculate of the 5 shifts, how much as a percentage is each staff member working over the month? (Or 6 months etc)
This is purely to figure out if A is working more nights/days than person B, so on and so forth....
Thanks in advance!!
Sent from my iPhone using Tapatalk
New to the forum. I need a bit of help.
I’m in charge of rostering where I work and I’m looking for a way to calculate a percentage of shifts worked by x amount of staff.
For example....
We have 5 shifts to cover throughout the day. 3 morning, 2 night. The the roster is monthly, every few days the staff change from days to nights and vise versa. How do I calculate of the 5 shifts, how much as a percentage is each staff member working over the month? (Or 6 months etc)
This is purely to figure out if A is working more nights/days than person B, so on and so forth....
Thanks in advance!!
Sent from my iPhone using Tapatalk