# 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?

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Expert

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!!!

Posted on Mar 04, 2008

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Open Questions:

#### Related Topics:

101 people viewed this question

Level 3 Expert

Level 3 Expert