Hi, i am trying to build an invoice solely for 1 customer only, because they are a pain in the a*s!! i am self employed hgv driver and the customer in question can change my rate as many times a 4 per shift and it is really hard to try and invoice them, especially as i am employing more and more drivers. i have put together a spreadsheet but dont know any formulas. in the spreadsheet i have (apart from the obvious ones) day hours, night hours, day o/t hours, night o/t hours, sat hours and sun hours. if i done 8 day hours, 2 day o/t hours and 1 night o/t hour, is there a formula that could calculate all the different rates if i put the hours in each seperate box, and it give me a total in the net column?
Tags: