sum time
Results 1 to 7 of 7

Thread: sum time

  1. #1
    New Member
    Join Date
    Feb 2011
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question sum time

    Hi

    I have a column with the following numbers

    00:00:15
    00:00:48
    00:02:02
    01:00:23
    00:23:54
    00:01:23

    These indicate the time spent waiting for a response.
    I want to be able to sum all these values but for that I need to make them recognizable to excel.

    How can I set these values are time and that excel allow me to sum them?
    What type of format do I need to use?

    thank you

  2. #2
    Board Regular
    Join Date
    Apr 2003
    Location
    England
    Posts
    5,890
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: sum time

    Have you tried to sum them? If they are entered as you show them then it should work.

    Code:
    00:00:15
    00:00:48
    00:02:02
    01:00:23
    00:23:54
    00:01:23
    01:28:45
    To post screen shots download the MrExcel HTML Maker
    Look here for other options Recommended Add-ins and Links

  3. #3
    New Member
    Join Date
    Feb 2011
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: sum time

    here is a screenshot




    the result is zero

    for sure I'll need to change the format but so far I haven't been able to.
    Last edited by livermore; Aug 20th, 2019 at 08:30 AM.

  4. #4
    Board Regular
    Join Date
    Apr 2003
    Location
    England
    Posts
    5,890
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: sum time

    Try

    =SUM(A1:A6+0)
    Enter as an array with Ctrl, Shift & Enter
    To post screen shots download the MrExcel HTML Maker
    Look here for other options Recommended Add-ins and Links

  5. #5
    New Member
    Join Date
    Feb 2011
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: sum time

    PERFECT!

    Thank you so much gaz_chops.

    You're the best!

  6. #6
    Board Regular
    Join Date
    Apr 2003
    Location
    England
    Posts
    5,890
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: sum time

    You're welcome.
    To post screen shots download the MrExcel HTML Maker
    Look here for other options Recommended Add-ins and Links

  7. #7
    Board Regular
    Join Date
    Apr 2003
    Location
    England
    Posts
    5,890
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: sum time

    This also works & is not an array formula

    =SUMPRODUCT(A1:A6+0)
    To post screen shots download the MrExcel HTML Maker
    Look here for other options Recommended Add-ins and Links

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •