Google Spreadsheets SUM – Getting SUM Function to Work in Google Spreadsheets

google sheets

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

Best Answer

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

Related Solutions

Google-sheets – Google Docs Time report – How to add hours

It may be a little late, but here is how I do it:

=HOUR(B2-A2)+(MINUTE(B2-A2)/60)

Basically, being B2 the end time and A2 the start time, you subtract B2-A2 and get the hour from the subtraction. Then you do the same and get the amount of minutes. After you have both, you sum the amount of hours with the amount of minutes divided by 60 (to get it in hours).

Don't forget to use the 24-hour format (i.e. 10:00 or 22:00).

Google-sheets – Parsing Time data in Google Spreadsheets

Solution

Suppose total distance is in column C1 and total time is in D1 then average speed formula would be:

=C1/(int(D1)*24+hour(D1)+minute(D1)/60+second(D1)/3600)

int function is the one I was after.

Best Answer

Related Solutions

Google-sheets – Google Docs Time report – How to add hours

Google-sheets – Parsing Time data in Google Spreadsheets

Solution

Related Topic