I am trying to create a new rota template in excel that can auto calculate and take off lunch hours for the week total and auto calculate if anyone is doing overtime.
I am relatively confident in excel but I can't for the life of me work out how this should be done.
For example bob has a 28hour contract and works 3 days of 9 Hour shifts and 1 day of 5 hours at differing times throughout the day. How can I make excel calculate that after 6 hours it needs to take an hour off for lunch and calculate overtime.
Many thanks as this is a bit out of my comfort zone
I am relatively confident in excel but I can't for the life of me work out how this should be done.
For example bob has a 28hour contract and works 3 days of 9 Hour shifts and 1 day of 5 hours at differing times throughout the day. How can I make excel calculate that after 6 hours it needs to take an hour off for lunch and calculate overtime.
Many thanks as this is a bit out of my comfort zone