Time and Motion Tracker
Table of Content
Download Template (Pro Version)
About the tool
Time & 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+Shift+A) or Stop (Ctrl+Shft+S) buttons to record the time stamp.
Note:
- If you want to add more columns in the tracker. Click on Reset and add them after column F (Duration)
- To avoid manual changes in the time tracked; Date, Start Time, End Time and Duration columns have been protected with a password
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.
- Save the tool copy in your system
- Unzip the file and open
- If you see a yellow bar mentioning macros have been disabled then click on Enable Content
- Click on ‘START’ or Ctrl+Shift+A when you start your transaction
- Click on ‘STOP’ or Ctrl+Shft+S when your transaction is complete
- Transaction ID and Remarks are option fields
- To reset the tracker and clear the tracked data, click on Reset button
Download Free Time and Motion Study Excel Template
