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

    RevToTheRedline

    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
     

    Attached Files:

  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.
     

Share This Page