VideoHelp Forum




+ Reply to Thread
Results 1 to 7 of 7
  1. Member lumis's Avatar
    Join Date
    Jan 2005
    Location
    the remnants of pangea
    Search Comp PM
    i looked around google & download.com for a time calculator.. i was unable to find anything decent..

    basically i'm looking for a program that would allow me to add a bunch of times together, or even just 2.

    here's an example:

    41 minutes 25 seconds +
    1 hour 23 minutes 18 seconds +

    and then give a result, and allow me to add or subtract from the total.

    i thought these programs would be plentiful, but i had no luck..

    any suggestions?
    Quote Quote  
  2. Microsoft Excel will do that.

    just type cells in the format HH:MM:SS and sum them together.
    "A beginning is the time for taking the most delicate care that the balances are correct."
    - Frank Herbert, Dune
    Quote Quote  
  3. Member lumis's Avatar
    Join Date
    Jan 2005
    Location
    the remnants of pangea
    Search Comp PM


    and then what do i do?
    Quote Quote  
  4. no, like this. I used your first 3 times

    notice the cell with the total is a function summing cells A1 through A3

    "A beginning is the time for taking the most delicate care that the balances are correct."
    - Frank Herbert, Dune
    Quote Quote  
  5. Member lumis's Avatar
    Join Date
    Jan 2005
    Location
    the remnants of pangea
    Search Comp PM
    okay, i've got all the times listed in the correct fashion.. what do i do to add them together?
    Quote Quote  
  6. find a cell and type
    =SUM(XX:YY)

    where XX is the first cell in the list and YY is the last

    in my screenshot see how cell A5 has
    "=SUM(A1:A3)" but displays "2:03:25"
    "A beginning is the time for taking the most delicate care that the balances are correct."
    - Frank Herbert, Dune
    Quote Quote  
  7. Member lumis's Avatar
    Join Date
    Jan 2005
    Location
    the remnants of pangea
    Search Comp PM
    thanks a million, worked perfectly.

    Quote Quote  



Similar Threads

Visit our sponsor! Try DVDFab and backup Blu-rays!