HI there,
I am assisting in re-designing a work roster for our workplace. We have 200+ staff members and there are about 20+ shift codes in use which has hours assigned to ranging from 0 to 12 hours. As we allow staff to self roster on a central spreadsheet, we want to have a column to add up the text shift codes they put in, so that it can tally up to see if they are over or under their hours for the month.
I have mocked up an example of what I am trying to achieve. I want to know what formula I can do in column "Weekly Total" to add up for each staff member for that week. Eg: Joe Smith will be 46 hours.
I hope that my explanation makes sense. As you can imagine our Real life roster is massive, so trying to find an automated way to do this!
Thanks in advance, LL_Livo
Example: Shift A equals 8 hours, B1=12hrs, S=10hrs, X=0, L=8
<tbody>
</tbody>
I am assisting in re-designing a work roster for our workplace. We have 200+ staff members and there are about 20+ shift codes in use which has hours assigned to ranging from 0 to 12 hours. As we allow staff to self roster on a central spreadsheet, we want to have a column to add up the text shift codes they put in, so that it can tally up to see if they are over or under their hours for the month.
I have mocked up an example of what I am trying to achieve. I want to know what formula I can do in column "Weekly Total" to add up for each staff member for that week. Eg: Joe Smith will be 46 hours.
I hope that my explanation makes sense. As you can imagine our Real life roster is massive, so trying to find an automated way to do this!
Thanks in advance, LL_Livo
Example: Shift A equals 8 hours, B1=12hrs, S=10hrs, X=0, L=8
<o></o> | 23/01/2017<o></o> | 24/01/2017<o></o> | 25/01/2017<o></o> | 26/01/2017<o></o> | 27/01/2017<o></o> | 28/01/2017<o></o> | 29/01/2017<o></o> | Weekly Total<o></o> |
Joe Smith<o></o> | A<o></o> | B1<o></o> | S<o></o> | L<o></o> | L<o></o> | X<o></o> | X<o></o> | <o></o> |
Anne Jones<o></o> | L<o></o> | S<o></o> | B1<o></o> | L<o></o> | X<o></o> | X<o></o> | A<o></o> | <o></o> |