Hi all,
I have a spreadsheet which contains names and shifts they work on - It also includes the week days.
The hours a person works are inputted on a daily basis and then the correct department is selected through a dropdown box to the right of the hours.
My objective is to make the sheet use a 'universal' formula which can be dragged across the sheet to make it all work by calculating the hours correctly across all departments. It also needs to take in consideration if that person has worked here for longer than 12 weeks which is calculated in column 'C'.
Columns from 'BR' onwards just work out the cost based on the hours inputted.
I assume this will be a lengthy IF statement but if someone can assess the document and see an easier way - that would be great!
Let me know if anyone can help!?
Thanks
Bookmarks