Table of Content
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
- Includes feature to hold/pause the timer
- Allows consolidations of multiple Time and Motion Trackers for analysis
- Summarize data by 7 types of views and instantly calculate efficiency
- Three types of charts under dashboard
- Settings to control Activity Names, Standard AHT and Working Hours
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
Follow the below video which details out how to use this tool.
Opening the tool
- Open the tool and you will see below screen
- If the macros are disabled, click on Enable Content button
Tracking Start and End Time
- Click on âSTARTâ or Ctrl+W when you start your transaction
- Click on âSTOP/ENDâ or Ctrl+E when your transaction is complete
- Enter Transaction ID, Activity and Remarks as required
- Repeat the steps for each transaction you do
Using Hold and Resume Timer
- In between the transaction if you want to hold the timer then double click on Hold hyperlink against the transaction
- 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
- Post completing the transaction, you can click on âSTOP/ENDâ or double click on End hyperlink
- The time duration for which the transaction was put on hold will appear in Hold Timer column
Consolidate Multiple Time & Motion Trackers
- 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
- Browse the folder where Time & Motion trackers are saved
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
- Click on âConsolidate Time & Motion Dataâ button
- Tool will now start reading the data from each file and will prompt confirmation message once consolidation is complete
- You can view consolidated data in âTime Studyâ sheet
Viewing and Analyzing Utilization
- To view the utilization summary of the data tracked in âTime Studyâ sheet, click on Utilization button or go to âUtilization Summaryâ sheet
- Click on âRefreshâ button
- You can also change the analysis options using âDisplay Optionâ button and choose the way you would like to analyze the data
Dashboard
- To view the dashboard, click on âDashboardâ button or go to âDashboardâ sheet
- 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
View by Activity â Shows are chart based on Activity Name, Transactions Processed, Average Duration and Average Hold Time
View by User ID / Name â Shows are chart based on User ID / Name, Transactions Processed, Average Duration and Average Hold Time
- View by Dates â Shows the chart based on Date, Transactions Processed, Average Duration and Average Hold Time
Settings
- 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
- 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
- Update the standard user working hours in cell H6 in hh:mm:ss format. This information is used for analysis in âUtilization Summaryâ sheet
- Update the day working hours in cell H8 in hh:mm:ss format. This information is used for analysis in âUtilization Summaryâ sheet
