Hello,

I've had help creating a decent rota for my staff for a small cafe.
I'm happy for people to use what I've got for themselves, so download the file and go for it.

What I'd love, is a separate tab whereby I can input a date range, and it tells me the hours the staff member has worked. I'd like column A to be data validated drop downs to choose the employees, then column B populates how many hours they've worked based on the date range selected.

Please help, this will make splitting tips and working out end of month hours a lot easier.

Thanks!ROTA 2.0.xlsx

Gavin

https://www.dropbox.com/s/0tw1fit7z5...02.0.xlsx?dl=0