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? Jul 5, 2013 at 14:32
• Didn't Notice It Did Came Up Like This , Jul 5, 2013 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 Jul 5, 2013 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). Jul 5, 2013 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! Jul 5, 2013 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

• What If I Merged To Cells ? How WOuld It Work out ? Jul 5, 2013 at 16:29
• I'm Also Trying to Get A Grand Total of all of those in one column , sorry about this :/ Jul 5, 2013 at 16:54
• Should work, but you've got to use the cell with the value usually the first. Jul 5, 2013 at 16:54
• For total use =SUM(first_cell:last_cell) I've updated my example Jul 5, 2013 at 16:57
• Alirght ! Thanks i see on your example while you're working on it, i'll let you know if i encounter problems, is there a way where i can like give Kudos or something like that in here ? man i really appreciate this Jul 5, 2013 at 16:57