Hi there, I have just taken a new job were I need to create a 4 week rota for a staff team of 8 people. I need to ensure that each person has their contracted hours for 4 weeks (say 156) and i need to be able to calculate every hour that i have put into the rota. I can do this on paper which is easy enough but time consuming and i want to create an excel document which will total the hours for me and save me lots of time. I have attached a copy of a typical rota. If i put into a cell 8/4 (as a service shift), is there a way of making excel read it as 8 hours? This way i can just drag accross someones shifts and it will just calculate their hours.
Any help much appreciated!!!
Cheers
Bookmarks