Work '08 Numbers ... calculating sum of time?

[RevToTheRedline]

Is there a formula in Numbers, that will calculate the sum of multiple entries of time.

Say I have a column of minutes and seconds such as 4:32, 5:05, 6:20, 3:36 and so on, is there a formula that will add those. I am making a spreadsheet to keep track of run time of something and I'd like to know total time, without having to manually add it up

 

[blodwyn]

What format are you using for the cells? The date/time format is for a specific date/time (i.e. 2:10am) rather than an elapsed time.

 

[exegete77]

Not as convenient, but as Excel, but here is something that works. Very clumsy. Put the time (not date and be sure that the format does not include date, only time) in C3, D3, E3, F3. Then put this formula in G3

=CONCATENATE(LEFT(C3, 1)+LEFT(D3,1)+LEFT(E3,1)+LEFT(F3,1)+LEFT((RIGHT(C3, 2)+RIGHT(D3,2)+RIGHT(E3,2)+RIGHT(F3,2))/60,1), ":", RIGHT(C3, 2)+RIGHT(D3,2)+RIGHT(E3,2)+RIGHT(F3,2)-(60*LEFT((RIGHT(C3, 2)+RIGHT(D3,2)+RIGHT(E3,2)+RIGHT(F3,2))/60,1)))

 

[blodwyn]

Here's another suggestion, using a different column for minutes and seconds

Cell B10 contains =SUM(B2:B7) which sums the minutes
Cell C10 contains =SUM(C2:C7) which sums the seconds
Cell C11 contains =C10/60 which converts the summed seconds into minutes
Cell B11 contains =B10+C11 which adds the summed minutes and summed seconds together, giving a total time in decimal minutes format
Cell B8 contains =INT(B11) which gives the total minutes minus the decimal minutes fraction
Cell C8 contains =(C11-INT(C11))*60 which converts the decimal minutes fraction back into seconds

 

[exegete77]

That obviously would be the best solution as it is much simpler and more expandable. I had assumed that it was given in the same cell.

 

[pascalpp]

use Duration format

not sure when this was added, but Numbers in iWork 11 has a Duration format that works perfectly for adding track times.