I'm trying to get something like this. These are all in minutes I guess it goes that way when I type them like this.

``````Number     Time     After Work      TOTAL
1          1:52       2:00         (Result Of Course)
2          3:54       2:00
3
4
5
``````

I'm trying to get to plus/add all the "time" plus "afterwork" divided by the number that has a registered value like 1 and 2. I don't know how to use excel (I don't know the terms or what the right formula is called).

I'm completely illiterate about this stuff and I really can't get through the formula explanations, tried couple of stuff but unfortunately failed that's why I'm here, hopefully I can get an answer right away

-
Sorry, it's really difficult to figure out what you're trying to do here. Could you try clarifying please? – Andrew Lott Jul 5 '13 at 14:32
Didn't Notice It Did Came Up Like This , – Jethro Jul 5 '13 at 14:35
docs.google.com/spreadsheet/… I want to Add AVerage Handle To To After Call Work And Divide It To The Numbers 1-10 And So On That Has A Value In alined To them Like Number "1" AHT 17:00 ACW 2:00 So Add 17:00 And 2:00 Divided By 1 And So On TO Like 16:54 Add To 0:56 "Plus The First Total From Number "1" " Dvided By 2 Im sorry i couldnt think of any better explanations – Jethro Jul 5 '13 at 14:57
@Jethro just some advice for the future. You don't need to right in sentence case for comments (capitals on each word). – ComputerLocus Jul 5 '13 at 15:13
@Jethro and your explanation still doesn't make sense. Now it sounds like you want an average, when your title says SUM. Can you possible provide an example of what you are trying to do, using hard values, rather then the ideal generated processed numbers? Put it into your question too! – ComputerLocus Jul 5 '13 at 15:14

Assuming Number is in `A2`, Time `B2`, after work in `C2` and the total in `D2`, put the following formula in `D2`

``````=(B2+C2)/A2
``````

Copy the formula in `D2` to `D3`, `D4` etc

Here's an example

-
Thanks @Fogest , I Really Appreciate This Cheers ! – Jethro Jul 5 '13 at 16:12
What If I Merged To Cells ? How WOuld It Work out ? – Jethro Jul 5 '13 at 16:29
I'm Also Trying to Get A Grand Total of all of those in one column , sorry about this :/ – Jethro Jul 5 '13 at 16:54
Should work, but you've got to use the cell with the value usually the first. – parkydr Jul 5 '13 at 16:54
For total use =SUM(first_cell:last_cell) I've updated my example – parkydr Jul 5 '13 at 16:57