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
Table of Content About the tool Tool Features Benefits System Requirements Tool Limitations How to use this tool About the tool Outlook Email Management Tool is an Excel based tool which works with Outlook 2010…
Hi Friends, today we are going to learn something which is more closure to many businesses. As the businesses going global and digital, there is a need to adopt the new way of tagging. Yes,...
Table of Content About the tool Tool Features Benefits System Requirements How to use this tool About the tool Time and Motion Tracker is an MS Excel based tool which helps you to track Start…
From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free VBA tool from...
[tek_sectiontitle st_title="About Employee Database Tool" st_title_tag="" st_subtitle_decoration="" st_title_color="#1e73be" st_separator_enable="separator_off" st_text_align="text-left" st_width="st_fullwidth"] Employee Database is an MS Access based tool to manage employee details. The tool supports upto 78 demographics for each employee such as Name,...
Watch Excel Tutorial Video - Dummy Data Generator Tool Table of Content How does testing help? How should I test my tool or application? How does Dummy Data Generator tool helps in testing? How do...