Question about Business & Productivity Software

1 Answer

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

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 265 Answers

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

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add


Business & Productivity Software Logo

Related Topics:

96 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides