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

Discussion in 'Mac Apps and Mac App Store' started by RevToTheRedline, Sep 16, 2008.

1. ### RevToTheRedline macrumors 6502a

Joined:
Sep 27, 2007
#1
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

2. ### blodwyn macrumors 65816

Joined:
Jul 28, 2004
Location:
Portland, Oregon
#2
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.

3. ### exegete77 macrumors 6502a

Joined:
Feb 12, 2008
#3
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)))

4. ### blodwyn macrumors 65816

Joined:
Jul 28, 2004
Location:
Portland, Oregon
#4
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

File size:
16.5 KB
Views:
4,681
5. ### exegete77 macrumors 6502a

Joined:
Feb 12, 2008
#5
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.

6. ### pascalpp macrumors member

Joined:
May 10, 2002
Location:
Brooklyn, NYC
#6
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.