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
Bookmarks