I think this may be something that's solved via a pivot table, but I'm not quite sure. It's something I could do instantly in a database, but I'm forced to use Excel at work, so I need to figure out a way of doing it in Excel!

I have a spreadsheet for the weekly rotas at work - one day to a sheet with a summary sheet at the end. On each sheet is a list of employees working that day and what hours they are working (e.g. "Dave | 12:00 | 20:00" (in A3-C3), "Fred | 10:00 | 14:00" (in A4-C4) and so on). From that, I have a formula that works out how many hours it is they are working, and from that I can work out the total number of hours worked by everyone that day (i.e. a sum of the hours each person works) and then the total number of hours worked (i.e. a sum of the total from each day) - which is used to see how many hours of staffing has been spent each week.

However, what I would like to do is to be able to have a 2nd summary sheet that lists all the staff that are n work that week and how many hours they are working in total. e.g. if Dave works Monday, Tuesday, Wednesday, and Friday from 12:00-20:00 on each of those days, & Fred works 10:00-14:00 on Monday and Thursday, it will say "Dave | 32" / "Fred 12", etc.

I'm sure this is remarkably easy for a semi-experienced Excel user, but I've always worked with databases rather than spreadsheets and so have no idea where to start, so any help would be appreciated!