Re hash of spreadsheets using up to date excel

I currently use 3 different spread sheets to track - company leads, staff hours and wages, and average rates per hour, I will attach a sample of one of the spreadsheets below - I have just upgraded to an iMac with the last excel on and I want to use this opportunity to re-vamp my spread sheets add some colour options etc - the one below is my CURRENT wage spreadsheet, at the moment I enter hours daily, but from 20th April I only want to enter weekly hours, I need an option to shows any hours at overtime rate 1 and overtime rate two. It also needs to show two different options in regards to holiday one to shows the days of holiday remaining and taken and one (for zero contract staff) to shows the HOURS of holiday taken - this is all linked to their pay rates - I want to be able to highlight any columns text etc in colour if I wish - it is likely that from your first draft we may need to make a few tweaks if needed - If all goes well with this sheet I would like you to do the other two. - SO this rate is just for one spreadsheet - any way if you take a look at this spreadsheet attached it will give you an idea of what I have been using, looking for something better with the adjustments mentioned. I am guessing as we do not need daily hours just weekly (we work on a 4 week pay run) also a BONUS box where I can enter amount of bonus and this to reflect on the PAY area totals