+ Reply to Thread
Results 1 to 5 of 5

Need help with calculating total time of a particular event/activity

  1. #1
    Registered User
    Join Date
    12-29-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Need help with calculating total time of a particular event/activity

    I have a sheet werein there are columns one with time that marks the start of an event/activity of a person and the other with the event/activity. I want to calculate the total time of a particular activity and the number of time that activity was done. I can use the Countif to calculate the number of times but totally confused about how to calculate the total time of a particular activity as the time column only gives me the start time. For ex: 8:05 Start of Break 8:10 QC Start 8:15 Start of Break 8:20 Coaching 8:30 End of break 8:40 QC End
    There might be multiple activities in between. So now how do I calculate the total time between different activities and then summing total time for particular activity etc. Is there a solution/formula/macro anything or do I have to do it manually by removing the difference between every activities and then adding the totals? Please advise.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Need help with calculating total time of a particular event/activity

    Hi shailesh and welcome to the Forum.

    ..Looks like to need a SUMIF function, but for berret answers, would you like to upload a sample workbook??
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    12-29-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Need help with calculating total time of a particular event/activity

    sorry had to get the raw file...could any one help me with this please either a formula, pivot or vba anything
    Attached Files Attached Files
    Last edited by shailesh; 01-13-2012 at 11:28 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Need help with calculating total time of a particular event/activity

    Hi shailesh

    Try this
    Please Login or Register  to view this content.
    It shows the time difference in hours & minutes

    Have Fun
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-29-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Need help with calculating total time of a particular event/activity

    Thank you Philb, but do I have to do this manually every time the status is changed and then add up the sum total???

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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