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

#### amorestcaecus

##### New Member
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!

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### Dryver14

##### Well-known Member
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>

 Cell Formula E2 =SUM(B:B) F2 =SUM(C:C)

<tbody>
</tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Replies
5
Views
191
Replies
2
Views
176
Replies
0
Views
123
Replies
1
Views
206
Replies
1
Views
140

1,196,020
Messages
6,012,902
Members
441,739
Latest member
Jeezer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back