Time and Motion Tracker Pro Version

About the tool

Time and Motion Tracker is an MS Excel based tool which helps you to track Start and End time of any type of transaction or activity. The tool is developed using VBA coding which helps you to protect manual manipulation in the data by the user. It is also easy to use, just click on Start (shortcut: Ctrl+W) or Stop (Ctrl+E) buttons to record the time stamp. This is professional version of our famous Time & Motion Tracker. This version includes features such as Hold Timer, Consolidation, Utilization Analysis, Dashboards etc.

Tool Features

Additional column for tracking Activity type for analysis
Time and Motion Tracker Pro Version
Includes feature to hold/pause the timer
Time and Motion Tracker Pro Version
Allows consolidations of multiple Time and Motion Trackers for analysis
Time and Motion Tracker Pro Version
Summarize data by 7 types of views and instantly calculate efficiency
Time and Motion Tracker Pro Version
Three types of charts under dashboard
Time and Motion Tracker Pro Version
Time and Motion Tracker Pro Version
Settings to control Activity Names, Standard AHT and Working Hours
Time and Motion Tracker Pro Version

Benefits

  • Save time in collecting and consolidating time & motion data
  • Get most accurate data for analysis
  • Analyze efficiency and easily identify area for improvements
  • Save time in creating dashboard with 3 types of inbuilt charts
  • Full control over the tool using settings

System Requirements

  • You need to have installed version of MS Excel 2010 or above

How to use this tool

Opening the tool

  1. Open the tool and you will see below screen
    Time and Motion Tracker Pro Version
  2.  If the macros are disabled, click on Enable Content button
    Time and Motion Tracker Pro Version

Tracking Start and End Time

  1. Click on ‘START’ or Ctrl+W when you start your transaction
    Time and Motion Tracker Pro Version
  2. Click on ‘STOP/END’ or Ctrl+E when your transaction is complete
    Time and Motion Tracker Pro Version
  3. Enter Transaction ID, Activity and Remarks as required
    Time and Motion Tracker Pro Version
  4. Repeat the steps for each transaction you do
    Time and Motion Tracker Pro Version

Using Hold and Resume Timer

  1. In between the transaction if you want to hold the timer then double click on Hold hyperlink against the transaction
    Time and Motion Tracker Pro Version
  2. Once you click on Hold hyperlink, the link will be changed to Resume. Double click on Resume hyperlink to resume the hold and continue the transaction
    Time and Motion Tracker Pro Version
  3. Post completing the transaction, you can click on ‘STOP/END’ or double click on End hyperlink
    Time and Motion Tracker Pro Version
  4. The time duration for which the transaction was put on hold will appear in Hold Timer column
    Time and Motion Tracker Pro Version

Consolidate Multiple Time & Motion Trackers

  1. If you have collected Time & Motion data from different users in separate files then you can use Consolidate feature of this tool to combine entire data into one file for analysis. For this, you need to click on “Consolidate” button on Time Study sheet
    Time and Motion Tracker Pro Version
  2. Browse the folder where Time & Motion trackers are saved
    Time and Motion Tracker Pro Version
    Time and Motion Tracker Pro Version

    Note:

    • Tool can consolidate data from sheets named “Time Study” in the files
    • All files should have same column header for accurate consolidation
    • Tool supports consolidation of .xls and .xlsm files
    • Row 6 in “Time Study” sheet of each file is considered as Header row
    • Data will be pasted after existing records in the file
  3. Click on “Consolidate Time & Motion Data” button
    Time and Motion Tracker Pro Version
  4. Tool will now start reading the data from each file and will prompt confirmation message once consolidation is complete
    Time and Motion Tracker Pro Version
  5. You can view consolidated data in “Time Study” sheet
    Time and Motion Tracker Pro Version

Viewing and Analyzing Utilization

  1. To view the utilization summary of the data tracked in ‘Time Study’ sheet, click on Utilization button or go to ‘Utilization Summary’ sheet
    Time and Motion Tracker Pro Version
  2. Click on ‘Refresh’ button
    Time and Motion Tracker Pro Version
  3. You can also change the analysis options using ‘Display Option’ button and choose the way you would like to analyze the data
    Time and Motion Tracker Pro Version
    Time and Motion Tracker Pro Version

Dashboard

  1. To view the dashboard, click on ‘Dashboard’ button or go to ‘Dashboard’ sheet
    Time and Motion Tracker Pro Version
  2. Here you can see three types of chart readily available for your reference
    • View by Dates – Shows the chart based on Date, Transactions Processed, Average Duration and Average Hold Time
      Time and Motion Tracker Pro Version
    • View by Activity – Shows are chart based on Activity Name, Transactions Processed, Average Duration and Average Hold Time
      Time and Motion Tracker Pro Version
    • View by User ID / Name – Shows are chart based on User ID / Name, Transactions Processed, Average Duration and Average Hold Time
      Time and Motion Tracker Pro Version

Settings

  1. To change the tool settings like name of the activities, Standard AHT (Processing Time), Working Hours, click on ‘Settings’ button or go to ‘Settings’ sheet
    Time and Motion Tracker Pro Version
  2. Update the name of the activities which appears in the Activity dropdown (refer column D on ‘Time Study’ sheet) in column A and update Standard AHT (Average Handling Time) in column B
    Time and Motion Tracker Pro Version
  3. Update the standard user working hours in cell H6 in hh:mm:ss format. This information is used for analysis in ‘Utilization Summary’ sheet
    Time and Motion Tracker Pro Version
  4. Update the day working hours in cell H8 in hh:mm:ss format. This information is used for analysis in ‘Utilization Summary’ sheet
    Time and Motion Tracker Pro Version