+ Reply to Thread
Results 1 to 5 of 5

Task Process Tracker

  1. #1
    Registered User
    Join Date
    01-08-2020
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 365
    Posts
    2

    Task Process Tracker

    Hi everyone, I've been using this site for years and really value everyone's time and the huge wealth of knowledge here.

    Just got a situation where I'm trying to make an easy way for my team to enter time they have taken to complete a listed task and it to calculate the average, but I don't want to have a huge list of individuals as we want to keep it annonamous, and to get the team average per task

    I've created a basic one but it's the tracker of how many instances isn't aligning with times, so we're not getting a true average of time taken per task.

    I think I've attached an example of what I have made so far,

    but I can't think of a way to have the list of time act as a event counter and as a record of time taken to complete to be averaged out.
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 01-09-2020 at 04:46 AM. Reason: Please refrain from unecessary requests in title. Thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Task Process Tracker - Some help would be awesome

    1st, I would remove the R1C1 reference style you are using, it can make reading formulas confusing. Change it under File/Options/Formulas/Working with Formulas.

    2nd because all you are interested in is an average time, why not just use whole numbers, instead of time?
    (15+13+30)/3 = 19.33 (this equates to 19:20 anyway)
    (although Im not really sure what you think the problem with your answer - 0:19:20 - is?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-08-2020
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Task Process Tracker - Some help would be awesome

    thanks for the reply,

    Yeah I'm trying to make a way to get the average time taken on each specific process. the layout can be changed, and everything is up to modification as we're trying to process map what we do and where time is spent at a team level. Just can't seem to find a way where I can use a list to do the 2 things (time taken and tally) at once.

    the closest analogy I can think of is like a swim team trying to record the times of each lap to the type of stroke. giving a total tally of laps swam, and then the overall time average per style.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Task Process Tracker - Some help would be awesome

    OK so what would some sample answers look like?

  5. #5
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Task Process Tracker - Some help would be awesome

    Please Login or Register  to view this content.
    C4 i.e. Frequency is less than the count of (>00:00:00) processing time, formula gives you the text "Check the processing time", else the average.
    Attached Files Attached Files
    Last edited by AliGW; 01-09-2020 at 04:03 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA for task tracker
    By Martines91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2019, 12:35 PM
  2. Need a Task Scheduler, To-Do List, and Status Tracker
    By stpeter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2015, 03:05 PM
  3. Need help automating task tracker for team= Please help.
    By jmawea in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-30-2013, 12:57 AM
  4. Task Tracker - Filtering by ascending date and exceptions
    By sk8ersquare in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2013, 01:36 AM
  5. Need Excel daily Task tracker template
    By fzzd2x in forum Excel General
    Replies: 0
    Last Post: 09-26-2012, 09:37 AM
  6. Task Tracker Spreadsheet
    By wildgoosed in forum Excel General
    Replies: 3
    Last Post: 05-13-2011, 06:19 PM
  7. Printing leaves EXCEL.EXE process in Task Manager
    By eeidfn in forum Excel General
    Replies: 1
    Last Post: 02-27-2006, 10:30 PM

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