Need to make an excel sheet made with formula to add the following details:
Dates with Tues, Thurs, Sat, Public holidays
Columns with total of these income
65% of total for Tues, Thurs
70% of tatal for Sat, Public hol (extra days)
Then adding these for each fortnight, adding total amount.
Then this file and another file (we have for Mon, Fri, Sunday) will need to go in one master file.
Finally fortnight amount should go to another word file with total summary, dates, invoice numbers etc.