Advanced Excel Techniques

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:

Excel VBA Master Tool Kit

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

Recommended Articles

Outlook-Email-Management-Tool

Advanced Excel Techniques | Excel VBA and Macros

Outlook Email Management Tool

Byexcelsirji

Outlook Email Management Tool is an Excel based tool which works with Outlook 2010 or above version and helps you to read, copy or move multiple emails from an Outlook folder and sub-folders on click of a button. The tool also supports extracting attachments from emails as well.

Duplicate Data Identifier

Advanced Excel Techniques

Duplicate Data Identifier Tool

Byexcelsirji

Duplicate Data Identifier is an MS Access based tool which helps to identify duplicates from any Excel based data. The tool supports up to 10 conditions and 25 types of matching conditions to find the exact duplicate. You can also define formatting conditions to first format the data before checking for duplicates.

Simplest Way to Create Excel Add-in

Advanced Excel Techniques

Simplest Way to Create Excel Add-in

Byexcelsirji

Excel Add-in helps you to extend the features of Excel application. Using Excel Add-in, you can perform custom actions in Excel such as formatting the data, doing complex calculations which are not possible through Excel formulas, Reading or Writing data in other Excel files and so many more actions.

index match function

Advanced Excel Techniques

Index Match in Excel

BySumit Shrimal

Index Match in Excel are powerful tools for advanced lookups. They’re popular because they’re incredibly flexible. You can use them to search horizontally or vertically, perform two-way searches, find values to the left of your search criteria, handle case-sensitive searches, and even search using multiple conditions. If you want to improve your Excel skills, mastering INDEX and MATCH is essential. Below, you’ll find numerous examples to help you grasp how they function.

employee-database-management

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

Employee Database Tool

Byexcelsirji

Employee Database is an MS Access based tool to manage employee details. The tool supports upto 78 demographics for each employee such as Name, Location, Phone, Email, Address etc. The tool also comes with inbuilt attendance tracker to track daily attendance of employees. Over and above this, you can also design your own trackers and start using it.

vba code to sum cells by color

Productivity and Automation | Advanced Excel Techniques | Excel VBA and Macros

VBA Code to Sum Cells by Color

Byexcelsirji

VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.

Excel VBA Master Tool Kit