Percentages help

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
 
Post a sample worksheet with your data showing a before and after scenario so that we can replicate what you have manually with an automated solution.
 
Back
Top