Advanced Excel Techniques

Time and Motion Tracker

Download Pro Time and Motion Dashboard Version

Table of Content

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.

Excel VBA Master Tool Kit

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

Recommended Articles

Time Management Tools and Trackers

Advanced Excel Techniques

Time Management Tools and Trackers

ByPradeep Kumar

Time Management is very effective way of managing the available time. Current competitive world is making the time management crucial. There are various ways, tools and techniques by which time management can be done easily.

VBA Code to Get User Name

Productivity and Automation | Excel VBA and Macros

VBA Code to Get User Name

Byexcelsirji

This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.

VBA Code to Read Outlook Emails

Excel VBA and Macros | Productivity and Automation

VBA Code to Read Outlook Emails

ByKailash Sharma

VBA Code to Read Outlook Emails Reading emails from Outlook and capture them in Excel file is very common activity being performed in office environment. Doing this activity manually every time is quite boring and…

How to use IFERROR Function in Excel

Excel Basics | Advanced Excel Techniques | Excel Functions

How to use IFERROR Function in Excel

BySumit Shrimal

This tutorial explains how to use the IFERROR function in Excel to catch and handle errors. It shows you how to replace errors with a blank cell, a different value, or a custom message. You’ll also learn how to use IFERROR with functions like VLOOKUP and INDEX MATCH, and how it compares to other error-checking functions like IF ISERROR and IFNA

Excel VBA Tool to Get File Properties

Productivity and Automation | Excel VBA and Macros

Excel VBA Tool to Get File Properties

Byexcelsirji

Excel VBA Tool To Get File Properties Here is one more interesting VBA tool from the ExcelSirJi team. File Properties Tool is an Excel VBA tool that gets the following properties of the file. File…

VBA Code to Delete File

Excel VBA and Macros | Productivity and Automation

VBA Code to Delete File

Byexcelsirji

In this article we are going to show you how you can delete file or files using a single line of VBA code. 1. Delete a specific file from the folder, 2. Delete specific type of files from the folder, 3. Delete all files from the folder

Excel VBA Master Tool Kit