time and motion

Table of Content

About the tool

Complete Excel VBA Course

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:

  1. If you want to add more columns in the tracker. Click on Reset and add them after column F (Duration)
  2. 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.
  1. Save the tool copy in your system
  2. Unzip the file and open
  3. If you see a yellow bar mentioning macros have been disabled then click on Enable Content
  4. Click on ‘START’ or Ctrl+Shift+A when you start your transaction
    Time and Motion
  5. Click on ‘STOP’ or Ctrl+Shft+S when your transaction is complete
    Time and Motion
  6. Transaction ID and Remarks are option fields
    Time and Motion
  7. To reset the tracker and clear the tracked data, click on Reset button
    Time and Motion

Recommended Articles

Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

Complete Excel VBA Course

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Lets get connected and start learning now. Click here to Enroll.

Want to Buy this tool?

time and motion

Similar Posts

File Manager Tool

File Manager Tool

Byexcelsirji

File Manager tool is an Excel based tool which helps you to delete or move unwanted files from your system. It requires a source and destination folder (in case you want to move files). First it lists all the files available in the folder or sub-folders then you can select the action to be taken for each file such as Move or Delete. With a click of button, tool will take all necessary actions.

VBA Code to Remove Duplicate Rows
|

VBA Code to Remove Duplicate Rows

Byexcelsirji

Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.