Spreadsheets Hi, i am trying to build an invoice solely for 1 customer only, because they are a pain in the ass!! 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?

You need to calculate the totals for each category, by entering a formula such as: = C2 * 12.00 where C2 is the location of the hours and your hourly rate is $12.00. You can fill in the C2 part in each formula by clicking on the cell you want the total in, then typing the equal sign, then selecting the cell that you want to get the hours from, then enter the multiply operator (asterisk *) which is a Shift + 8 on your keyboard or the * over the 9 key on the numerical keypad. Repeat for each entry, using the correct cell and the correct amount (in this example it might be $18.00 for overtime hours). Then you just total all the formulas by using Autosum, which you invoke by using the Ʃ symbol, which will give you a sum of the cells you select. If this isn't clear enough, please let us know.

Hope this will FixYa!!!