Excel newbie, I mean really new! Need help with starting!

[amorestcaecus]

Basically i would like to use excel to calculate the total hours i spent working on something, and how much i earned working.

For example, I spent 7 minutes on a task and was paid $3. I did another task for 10 minutes and was paid $2.50.
I would like to have these two tasks added so that, say, by the end of the week when I add up all of my minutes (in this case 17 minutes) it would total to $5.50 for that week.

I would like to have it so that I can create a new one for each week. the picture i attached is all that i have so far lol! Im completely lost!

thanks for your help in advance!!!

 

[Dryver14]

Good morning,

As you are completely new I have kept this as basic as possible so minutes are just counted without changing to hours or minutes.

I have put some headings on for you.

I also suggest you place the mouse on the sheet name at the bottom and right click then select change sheet name and change it to
Week1 etc so you know what sheet to go to.

Hope this helps.

Sheet1

	A	B	C	D	E	F
1	Date	Time	Amount		Total Time	Total Amount
2	01/03/2003	17	£ 1.53		135	£ 37.50
3	02/03/2003	15	£ 4.60
4	03/03/2003	12	£ 3.00
5	04/03/2003	11	£ 2.87
6	05/03/2003	45	£ 13.00
7	06/03/2003	23	£ 8.00
8	07/03/2003	12	£ 4.50

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 75px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 72px;"><col style="width: 92px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula E2 =SUM(B:B) F2 =SUM(C:C) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4