Hi All,
I'm not sure if this is possible to do with my current approach, so any direction is welcome. Please excuse any errors with my terminology also.
The result I am aiming for is to have a sum total of hours for staff listed on a staff rota. Ideally I am trying to search across a field of various positions for initials indicating which staff are assigned which positions. I would then need to add the hours per shift, which are listed in an adjacent cell to find the total hours assigned per week.
In the attached file is an example of one day. As you can see, staff can work multiple positions in a day (for example, "CF" is in two positions). Is there a way I can scan the document for "CF", and then somehow add the associated shift length (listed in the adjacent column, "C" in the example)
so the document can automatically tell people that CF has 7 hours, LM has 7.5 Hours, etc? I'm not sure if a VLOOKUP would work for this scenario?
Or if I am approaching this from a crazy angle (I'm aware I might be blinkered here!) could someone nudge me in a more appropriate direction?
Thanks for reading.
Bookmarks