+ Reply to Thread
Results 1 to 4 of 4

Compare dates & add time for each task done during the day

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Athens
    MS-Off Ver
    Excel 2011 mac
    Posts
    2

    Compare dates & add time for each task done during the day

    Hello,

    I have the following issue to address and someone might help...

    I have a column with dates and next to each date I have amount of time a task took to complete for the given dat.
    Now, on the same day one or more than one tasks could be completed. So I might have the following:

    24-May-12 0:01:31
    24-May-12 0:04:08
    5-Jun-12 0:10:18

    Now, I would like to have a sum where in one column I have the date and next to it the total amount of time it took for all tasks to finish for the given date. For the example above I would like to have:
    24-May-12 0:05:39
    5-Jun-12 0:10:18

    I would appreciate if you could help me on this!
    Thanks!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Compare dates & add time for each task done during the day

    Use SUMIF, for example in E1:

    =SUMIF(A:A,D1,B:B)

    where column A has your individual dates, column B has the individual times, and D1 contains 24-May-12. Format the cell E1 as [h]:mm:ss and copy it down if column D contains the other dates you are interested in.

    Hope this helps.

    Pete

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Compare dates & add time for each task done during the day

    perhaps use pivot tables...

    www.cpearson.com/excel/pivots.htm
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    10-02-2012
    Location
    Athens
    MS-Off Ver
    Excel 2011 mac
    Posts
    2

    Re: Compare dates & add time for each task done during the day

    thanks for your replies!

    pivot tables did the job for me!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1