Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 

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

share|improve this question
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
up vote 0 down vote accepted

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


Copy the formula in D2 to D3, D4 etc

Here's an example

share|improve this answer
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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.