VBA Tool to Track Start and End Time (Time & Motion Tracker)


33

Here is one more wonderful free tool from ExcelSirJi.com which makes your life easy. Time & Motion Tracker helps you to track Start and End time of any type of transaction or activity. The good thing is, it is VBA based tool which helps you to protect from 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

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

Excel Tricks

How to use this tracker:

1. Save the hyperlink attachment in your system Time & Motion Tracker
2. Unzip the file and open
3. Click on ‘START’ or Ctrl+Shift+A when you start your transaction

Excel Tricks

4. Click on ‘STOP’ or Ctrl+Shft+S when your transaction is complete

Excel Tricks

5. Transaction ID and Remarks are option fields

Excel Tricks

6. To reset the tracker and clear the tracked data, click on Reset button

Excel Tricks

33
Leave a Reply

avatar
15 Comment threads
18 Thread replies
1 Followers
 
Most reacted comment
Hottest comment thread
17 Comment authors
Caroline WJohn KJohn KjperaltaDonna Miranda Recent comment authors
newest oldest most voted
Ravi Thakur
Guest
Ravi Thakur

Hi,

Can you please email me this template ? @ ravi_thakur34@yahoo.com

Thanks for your help 🙂

Pat
Guest
Pat

how do i unprotect this sheet?

Sujit
Guest
Sujit

can u pls send me this time and motion template to me. its look good and i need it to implement.

Mark
Guest
Mark

Can you send me a copy of the template please.

Michael Castro
Guest
Michael Castro

Hi,
Started using the template and it is really very useful .
Great job!

Christian
Guest
Christian

Hi,

Having an error when stop time. Pls help. Thank you

Basic runtime error. ‘1’

MAnish Kumar
Guest
MAnish Kumar

Hey, can you mail me this, I am doing a time and motion study, it would actually help

Carol
Guest
Carol

Hello,
I’ve downloaded the sheet but the password does not work, can I double check it is pwd@123 password.?

Clare C
Guest
Clare C

I cannot seem to get this to work it says ‘compile error, cannot find project or library’. thanks

Dan
Guest
Dan

Hi: Love the tracker, jut what I am looking for. I want to add a way to export a report based on the data gathered. I’m having an issue with the password. was it pwd@123 password ? I’ve tried with the word password, with a space between the 3 and… Read more »

Kiran
Guest
Kiran

Hi,

Could please send me this VBA code to my email id kiran6932@gmail.com

Donna Miranda
Guest
Donna Miranda

Thanks so much for this file. Really helpful! 🙂

jperalta
Guest
jperalta

Where’s the link to download?

John K
Guest
John K

I have added a new column ‘G’ to lookup type of transaction ID. However when I click ‘Reset’ button, the formula in column G are erased. What is the password for the VB code so I correct this?

Caroline W
Guest
Caroline W

Hi. I am trying to use the Time and Motion Tracker but am struggling with the un-protect function for additional columns. I have created 2 additional columns (work type) with drop down lists but it asks me to un-protect for each individual line (even though I’ve un-protected the whole worksheet?… Read more »

VBA Code to Sum Cells by Color
VBA TRICKS
VBA Code to Sum Cells by Color

Recently some of our subscribers have requested us to share a VBA code that can sum the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to sum the cells with specific color and returns the total sum of the matching color cells

VBA Code to Delete File
VBA TRICKS
VBA Code to Delete File

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

VBA Code to Add Border to Excel Range
VBA TRICKS
VBA Code to Add Border to Excel Range

Through formatting the cells, you can make your Excel data more beautiful and easier to understand. If you record a macro to add borders to Excel range, you will notice that it generates 30 plus lines of code for just a small work. Here we are sharing one line of code which does the same thing.

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn