Excel Equation

[gizbug]

If i have 2 colums, 1 is "time this lesson" and the next is "total time" how do I make an equation that calculates the total time from the previous times?

 

[Kyteland]

=sum(A:A)

This totals everything in column A

Or if you want a running total (ie, something that will fill down) you can use an equation like this

=SUM(A$1:A#)

Where '#' is your current row

 

[HomeBrewerDude]

Originally posted by: gizbug
If i have 2 colums, 1 is "time this lesson" and the next is "total time" how do I make an equation that calculates the total time from the previous times?

whaaa!?


1) do you have 3 columns or 2?

begin time | end time | total time



just subtract begin from end. Excel can do time calculations.